Forum Discussion
countif statement about multiple conditions
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?