Articles

Countif with multiple conditions

February 25, 2009 at 12:43:33
Specs: Windows 2000

I need to count occurances of a certain entry but only if another cell has a certain entry. For example:

I have 5 groups, Item, Description, Preprint, Description and Count. The first Description category is variable and will change from entry to entry (It could be green, red, blue, ect.). The second Description category lists all the possibilities for the description. I want to count how many times a description appears, but only if there is a 1 in the corresponding "Preprint" cell. If it would work, the formula would look like this:

This would be entered into cell E2:
COUNTIF($A$2:$A$5,=D2)AND COUNTIF(C2,=1)

If we are talking about frogs, I want to know how many(Count) Frogs(Item) are blue(Description) and have are PrePrinted (PrePrint).

Can anyone help?


See More: Countif with multiple conditions

Report •


#1
February 25, 2009 at 13:51:30

Search this forum. Your question has been answered multiple times. In fact, there are some similiar posts listed in the "Related Posts" box.

Report •

#2
March 24, 2009 at 22:37:27

Hi, i could also not find the count formula which 'tiatoangels' was asking.
The ones in 'Related Posts' talk about sum's of counts.
I just want to count once where 2 conditions are met.
eg
TOYS GENDER
Doll Girl
Brush Girl
Truck Boy
Car Boy

Count where Toys=Doll and Gender=Doll.
The answer should be 1.

Please help


Report •

#3
March 25, 2009 at 20:10:09

re: Count where Toys=Doll and Gender=Doll.
The answer should be 1.

Based on your data, shouldn't the answer be 0?


Report •

Related Solutions


Ask Question