Formula for summing up row/column values

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

I did try the solution that you proposed. however it leads to a circular reference error....does that mean i have to specify the exact row/columns in the range?

Thanks for all your help.