Forum Discussion
countif statement about multiple conditions
Please let me know what is wrong below function.
=COUNTIF(ABC!A:A,"dog",ABC!Y:Y,"cat")
Thank you.
Hi Hirofumi
Countif can't have two conditions.
I've attached a spreadsheet that basically splits up the columns to calculate each.
See what you think?
Cheers
Damien
Damien, I have a similar problem to Hirofumi. But I need to say, count all animals that weigh more than 10 pounds, dogs and cats... I would add another column to your spreadsheet inputting the weights of the animals... Is there another formula besides COUNTIF or a way to use conditional formatting for color... say I colored all the dogs and cats that weighed more than ten pounds green, then is there a formula to just say COUNTIF the box is green?
I need something like this COUNTIF(range,">10" & another range,">10)
or Count all the green boxes in a certain range
This problem has plagued me for three years. I always have to add them up manually, and there should be a way to do it in EXCEL, I just don't know what it is.
Thank you, Dominique
Why don't you use COUNTIFS?
