Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|