| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF cells in Column B are blank
I am trying to figure out how to sum numbers in column A but only if the
cells in the corresponding row in column B are blank. Any ideas? I thought this would work but it hasn't so far =SUMIF(B:B, ISBLANK(B:B), A:A) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF except for blank cells | Excel Discussion (Misc queries) | |||
| SUMIF does not work with blank cells | Excel Discussion (Misc queries) | |||
| Sumif Cells Are Not Blank | Excel Worksheet Functions | |||
| Sumif function does not add up cells, even when criteria is blank | Excel Worksheet Functions | |||
| Using SUMIF with non-blank cells | Excel Worksheet Functions | |||
Threaded Mode
