Hi,
I am new to excel. Below is what I need. Is there any possibility that I write a formula for a column and it caliculates the particular rowtotal minus the particular column total for each cell in that column insted of writing formula for each cell.
I need (particular
row total - particularcolumn
total)
total of rows
1 2 10 13 13-13
4 5 7 16 16-15
8 8 9 25 25-26
total of 13 15 26
columns
If you observe first colun in last column in first row is the total row1-totalcolumn1, last column in second row is totalrow2-totalcolumn2 and same way is the third column. Is tehre any way to write a formula for the last column so that it automatically does the math for each cell of that column.
I can not write the formula for each cell as there is huge data.
Thanks in advance.
Bookmarks