If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula to Sum values in word table | Craig | Mailmerge | 1 | August 29th, 2005 06:19 PM |
Copying formulas with mixed references | TMcMillin | Worksheet Functions | 6 | August 16th, 2005 06:40 PM |
Formulas in chart series references | Guackyxxx | Charts and Charting | 2 | June 12th, 2005 11:35 PM |
Replicating Formulas with Various Worksheet References | Cloudburst99 | Worksheet Functions | 1 | January 20th, 2005 11:15 PM |
Continuing the cell references in formulas | Kreller | General Discussion | 8 | July 13th, 2004 01:07 PM |