Count number of cells matching 2 criteria

[sharky12345]

I'm trying to count the number of times a non-blank cell is found if another column value matches a criteria;

=COUNTIFS(Resourcing!$B$2:$B$23,A14,Resourcing!$H$2:$H$50,< >"")

So in this case, I am first looking in B2:B23 to find a value that matches A14, then if it matches I want to count how many cells are not blank between H2:H50.

Can someone give me some guidance please as the above does not work but I have no idea why?

 

[jtakw]

Hi,

Try this, adjust formula with your tab names:

=IF(COUNTIF(B2:B23,A14)>=1,COUNTIF(H2:H50,"<>"),"")

 

[sharky12345]

Perfect!

Thanks!!

 

[jtakw]

You're welcome.