How can I calculate the sum value of other table's from one cell?
- Thread starter uday
- Start date
uday
Member
In table 1 total sum is 150 and cell value is C7...I want to calculate other table's sum value from C7 but the expected result need to show in other table total value....separately..
Like in Table 1 = 150 table 2 =? tbale 3 =?..
I do not want to see the total amount of all tables price total in one cell but I want calculate other table sum value from that particular cell 7.
Like in Table 1 = 150 table 2 =? tbale 3 =?..
I do not want to see the total amount of all tables price total in one cell but I want calculate other table sum value from that particular cell 7.
NARAYANK991
Excel Ninja
Hi Uday ,
If your Excel version allows it , get into the habit of using Tables ; everything becomes that much simpler.
See the attached file , which does the same job as the one uploaded by Bhawani , but without the same manual involvement ; since the data is in the form of tables , the formulae for the totals will automatically reflect addition of new rows in any table ; referring to the columns is also easier , since you can use the column header labels.
Narayan
If your Excel version allows it , get into the habit of using Tables ; everything becomes that much simpler.
See the attached file , which does the same job as the one uploaded by Bhawani , but without the same manual involvement ; since the data is in the form of tables , the formulae for the totals will automatically reflect addition of new rows in any table ; referring to the columns is also easier , since you can use the column header labels.
Narayan