Formula: Countifs

[jaime1182]

Hi guys

I'm trying to put together a countifs statement but am getting a little stuck.

I want the formula to calculate how many blanks are in the corresponding C column, if the value in the B column is 5.

I managed the first condition (to count how many 5s there are in B):
=COUNTIF(B2:B10,5)

However, I don't know how to then get it to test the next condition whereby of the cells with 5, how many have blanks cells next to them in column C.

Looking forward to anyone's reply.

 

[jlylejr426]

Try this =COUNTIFS(B2:B10,5,C2:C10,"")

 

[jaime1182]

That works great!! Thank you so much!

 

[jaime1182]

Just another query. I did not consider this initially but have now realised that I need to check Column C for another factor.

Column C could either be blank or could have the value "Hold". I need to count both the blank and the Hold ones.

I tried to use OR but ended up with a "You've entered too few arguments for this function".
=COUNTIFS(B2:B10,5,OR(C2:C10="",C2:C10="Hold"))

What is wrong with my statement?

 

[Nishant94]

Book1
	B	C	D	E	F
1
2	5	Hold		Answer	2
3	6	d
4	2	d
5	3
6	5
7	6
8	9
9	5	f
10	6
11
Sheet7

Cell Formulas
Range	Formula
F2	{=SUM(COUNTIFS(B2:B10,5,C2:C10,{"","Hold"}))}
Press CTRL+SHIFT+ENTER to enter array formulas.