I need a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top