I need a formula

T

TheDrip

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.
 
R

Roger Govier

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
Arriving at totals 2
List all tables, including document structure 0
Autonumber field in Excel that behaves the same as Access 0
Copy addition formula of non-consecutive horizontal cells 2
Incone & Expenses Statement 0
Help with column accumulation needed 2
Page numbering with Merged Document and IF statements 1

Top