| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with SUMIF formula
I need someone to help me please.
Example: cell a2 = 5,000 cell a3 = 10,000 cell a4 = 90 cell b2 = "blank" cell b3 = 5,000 cell b4 = 90 i am writing a SUMIF problem =sumif(a4:b4,90,a3:b3) but what i need is the sum of cells a3 if a2 is blank, if cell a2 has a number then i need that number. in other words the total of this formula needs to = 10,000 not 15,000. Can anyone help me? Susan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sumproduct formula within a sumif formula. | Excel Discussion (Misc queries) | |||
| multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
| Formula for If - SUMIF | Excel Discussion (Misc queries) | |||
| Sumif and And formula | Excel Discussion (Misc queries) | |||
| Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
