Count conditionally

  • Thread starter Thread starter Nader
  • Start date Start date
N

Nader

I am trying to calculate the number of cells in one
column that contain a certain item if other cells in
another column contain certain criteria. For instance, I
want to know how many red apples do I have; the answer
would be two only.

color fruit
Red Apple
Yellow Apple
Green Apple
Yellow Lemon
Green Lemon
Red Apple

Thanks for the help.
 
Nader,

One way is with a pivot table. The steps vary depending on your release of
Excel. You'd use the Color Fruit column in both the row/column area and the
data area, setting the data area from Sum to Count.

Another is with formulas:

=COUNTIF("A2:A10", "Red Apple")

Earl Kiosterud
mvpearl omitthisword at verizon period net
 
Back
Top