
1. Re: Question regarding calculating a formula to add three tables of numbers
pguerett Oct 9, 2009 8:29 AM (in response to dlnealmta)I think part of your issue is not having unique names for each field. If you do not then you have to use occurance numbers on the form (that is what I did).
See my attachedrevised sample.
Paul

2. Re: Question regarding calculating a formula to add three tables of numbers
dlnealmta Oct 9, 2009 11:29 AM (in response to pguerett)Thanks for a quick response but I noticed also that some of my cells in the table were not numeric so I changed it. The Subtotal is not working. I am getting an error. Your formula was working but it did not include the last total of numbers. It should include tables 6, 7 and 8 totals. Can you look at it again. Thanks again!!

3. Re: Question regarding calculating a formula to add three tables of numbers
pguerett Oct 9, 2009 11:54 AM (in response to dlnealmta)I modified the formulas .....I see how Table3 and Table 7 are used but it looks like Table8 is the total field....am I missing something?
Paul

4. Re: Question regarding calculating a formula to add three tables of numbers
dlnealmta Oct 9, 2009 11:59 AM (in response to pguerett)Yes, table 8 is supposed to have the total of all tables from 6, 7 and 8 in each column but maybe it is the way I designed it that makes it confusing.

5. Re: Question regarding calculating a formula to add three tables of numbers
dlnealmta Oct 9, 2009 12:29 PM (in response to dlnealmta)Did you send the document because it was not attached?

6. Re: Question regarding calculating a formula to add three tables of numbers
pguerett Oct 9, 2009 12:32 PM (in response to dlnealmta)Sorry my error.
Paul

7. Re: Question regarding calculating a formula to add three tables of numbers
dlnealmta Oct 9, 2009 1:06 PM (in response to pguerett)There are only two tables 6 and 7 that are being added. Table 8 is not being added in with the Total. Table 8 is where Total is listed. If you put numbers in the last table 8, I would like for it to add those plus the two other tables above as one total.