| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Sum of 2 columns if one is filled?
I need help with a formula. I have two columns - E (projected revenue) and M
(actual revenue). If M has a total in it, I want to ignore the same row in E, so that the actual revenue is added in to the total sum at the bottom along with the projected (if there isn't an actual amount) in column M. The sum is E166. The columns are E2:E165 and M2:M165. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filled cells dont appear as filled | Excel Discussion (Misc queries) | |||
| Columns with missing data that needs filled in | Excel Worksheet Functions | |||
| Select filled region only in non-adjacent columns | Excel Discussion (Misc queries) | |||
| Last filled row | Excel Discussion (Misc queries) | |||
| show me a filled in timecard example? | Setting up and Configuration of Excel | |||
Threaded Mode
