IF then COUNTBLANK formula not working for me

[manzier]

Hi all

I'm trying to count the blank cells where the status is not closed using this formula

=IF(B2:B6,"<>Closed",COUNTBLANK(A2:A6))

However, I'm getting a #VALUE error. Any suggestions on why it wouldn't work? Thanks!

Data	Status
2	Closed
2	In Process
	Closed
3	Closed
	Open
	Open

<tbody>
</tbody>

 

[bbott]

Try using COUNTIFS:

=COUNTIFS(A2:A6,"",B2:B6,"<>Closed")

 

[Momentman]

Like this:

Excel 2010
	A	B	C	D
1	Data	Status
2	2	Closed		2
3	2	In Process
4		Closed
5	3	Closed
6		Open
7		Open
Sheet2

Cell Formulas
Range	Formula
D2	=COUNTIFS(A2:A7,"",B2:B7,"<>"& "Closed")

 

[manzier]

Thanks guys, that did the trick