SUMIFS on blank cells

[knightwriter]

Hi all,

I am using the SUMIFS formula with 5 criterias. It works fine when the fifth criteria is equal the column header (ie >25% probabilty etc) but I want the forumla to now sum the cells where no probability has been input ie the cell is blank.

So: sum column A ($ amount) when column B (probability) is blank. I have tried "" with no luck, any suggestions. I am using excel 2013.

Many thanks

 

[AlanY]

it works for me

Excel 2012
	A	B
1	1
2	1
3	1	X
4	1	X
5	1
6	1	X
7	1
8	1
9
10	5
Sheet2

Cell Formulas
Range	Formula
A10	=SUMIFS(A1:A8,B1:B8,"")

 

[knightwriter]

thank you, no sure what the issue was but yes, it is working now.