Multiple Functions

[robstark]

I have 2 columns and I need the formula to read column "A" first and if it meets a certain criteria to look at column "B" and count if there's any text in the cells. See the example to show what I'm looking for. I would want the formula to look at column a for pet type (e.g. dog) and then look at owner's name (any text in that column gets counted) and give me the sum (in this case 3). I've tried a couple of things and I'm running out of time.

Example:
[TABLE="class: grid, width: 163, align: left"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Pet Type[/TD]
[TD]Owner's Name[/TD]
[/TR]
[TR]
[TD]dog[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]dog[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]dog[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]dog[/TD]
[TD]Jane[/TD]
[/TR]
[TR]
[TD]dog[/TD]
[TD]Dan[/TD]
[/TR]
[TR]
[TD]cat[/TD]
[TD]Mollie[/TD]
[/TR]
[TR]
[TD]cat[/TD]
[TD]Mary[/TD]
[/TR]
[TR]
[TD]cat[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]cat[/TD]
[TD]Scott[/TD]
[/TR]
[TR]
[TD]bird[/TD]
[TD]George[/TD]
[/TR]
[TR]
[TD]bird[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]fish[/TD]
[TD]Bill[/TD]
[/TR]
[TR]
[TD]fish[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]fish[/TD]
[TD]Betty[/TD]
[/TR]
</tbody>[/TABLE]

Thanks as always!

 

[Jonmo1]

Which version of Excel are you using?

XL2007+ Try
=COUNTIFS(A2:A15,"Dog",B2:B15,"<>")

 

[My Aswer Is This]

Try this:
This formula assumes your data is in cells A1:A20 and B1:B20
Put this formula in cell D1.
Put the word "Dog" in cell C1
You can modify the formula if you like.
Optional:
You can take the formula in cell D1 and fill it down.
Then put "Cat" in cell C2 and so on if you like.

=COUNTIFS($A$1:$A$20,C1,$B$1:$B$20,"<>")

 

[robstark]

jonmo- I tried this one but I got a value error- I must be missing something.

 

[robstark]

My Answer Is This- This one worked great! Thank you very much!