I need help with a form that I would like to show the Total of numbers from Table 6, 7 and 8. I have put in codes for the Subtotals but the final total I can't seem to figure out. Can someone help me with the coding to add subtotal 1, 2 and 3.
Thanks
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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!!
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Did you send the document because it was not attached?
Views
Replies
Total Likes
Sorry my error.
Paul
Views
Replies
Total Likes
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.
Views
Replies
Total Likes