| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totals skipping columns
I have data that is entered into each column by different people. Each
column is totaled. Below the column total is a running total with each column added to the last. The formula used for that column is: =IF(AND(E18,F17),E18+F17,""). What I need is that if a column or even two is not filled in I need the total, basically skipping the empty columns. Is this possible? Thanks for any help offered!!! Mike Rogers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I wrap Excel columns in a printout? | Excel Discussion (Misc queries) | |||
| Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
| Pivot Table Totals | New Users to Excel | |||
| skipping columns | Excel Worksheet Functions | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
