Table formulas and references

  • Thread starter Thread starter Stephen Glynn
  • Start date Start date
S

Stephen Glynn

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
 
Stephen said:
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
Click to expand...

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
 
Back
Top