Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Table formulas and references
I want to take the total of column B in table_1 and, in cell in another
table, multiply it by 17.5%. Assuming I've bookmarked table_1 as "my_table_1", what's the formula? I seem to be doing something wrong somewhere! Steve |
#2
|
|||
|
|||
Table formulas and references
Stephen Glynn wrote:
I want to take the total of column B in table_1 and, in cell in another table, multiply it by 17.5%. Assuming I've bookmarked table_1 as "my_table_1", what's the formula? I seem to be doing something wrong somewhere! Steve Sorry. I've worked it out. I've had to create some separate tables containing just one row and two columns (one for the formula and one for a label), one of which holds =sum (my_table_1 b:b). This table I've bookmarked as 'subtotal'. The next table contains =sum (subtotal b:b) *17.5% and the last one contains =sum (subtotal b:b) + sum (tax b:b). I needed to make sure the range in my_table_1 was a dynamic range so I can add an indeterminate quantity of items together before calculating the tax. Now, if I email this as an attachment to someone, can they save it as a template and use it? Steve |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to Sum values in word table | Mailmerge | |||
Getting rid of zeros in formulas | Tables |