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