Hi All,
I have some dynamic data which is displayed in excel. The number of rows/columns can vary.
eg

----A----B----C-----D-----E
1-------Tot
2 Tot-------10---14---18
3--------6-----1-----2----3
4--------15----4-----5----6
5--------6-----1-----2----3
6--------15----4-----5----6


I am clueless as to what formula needs to be set up to calculate the sum of column values (in row 2) and sum of row values (in column B).

any kind o f help would be appreciated.

thanks