I need a formula
 

I have a table with 5 columns with each column being totaled. I also total
the totals. My problem is not all 5 columns are used all the time but i
still need to add the columns that are used. I know there is a formula to do
that. Some one pls help me.

I need a formula
 

Hi

Lets say you have in A101
=SUM(A1:A100)
which is also copied across through B101:E101

In F100 enter
=SUM(A100:E100)
If any column is not used, there will be nothing in the row 100 of that
column, hence your result will still be correct.

--
Regards

Roger Govier


"TheDrip" wrote in message
...
I have a table with 5 columns with each column being totaled. I also
total
the totals. My problem is not all 5 columns are used all the time but
i
still need to add the columns that are used. I know there is a
formula to do
that. Some one pls help me.