Combined Count assistance

[Mystic484]

I understand that countIF can be used to set a criteria based on a value, and countBlank can be used to count the blank cells. What I've been unable to do is combine these functions. I am looking for a function to determine if cell A contains 1 of 3 values AND B is blank, then it will count all the blank cells in that range. I've tried sumProduct, but something I'm doing isn't returning the correct information cause it always returns 0 when i have several thousand empty rows in my range.

Based on my example below it would return 2, since row 9 and 10 have no data.

Col. A Col. B
1 John Cat
2 June Cat
3 Cat
4 John Dog
5 June Dog
6 Carlos Dog
7 Dog
8 Carlos Hamster
9
10

 

[p45cal]

perhaps:

Excel Workbook
	A	B	C
30	John	Cat	1
31	June	Cat
32	Cat
33	John	Dog
34	June	Dog
35	Carlos	Dog
36	Dog
37	Carlos	Hamster
Sheet24

 

[Mystic484]

This explained why my sumproduct function didn't work, but it doesn't take into account empty rows. The data that I'm pulling from is highly variable and I'm trying to avoid having to modify the formula every time the source changes.

 

[Mystic484]

Nevermind this did exactly what I was looking for. It didn't appear like it did when i made the statement but it worked correctly in the large scale.