=SUMPRODUCT((A2:A8="apples")*(D2:D8="red"))

Tyro

"Rae" wrote in message
...
I want to count the number of record/rows that have a true condition when
column A and Column D equals "red apples"; how do I do this?

Example:
cell range a2 - a4 = apples
cell range a5 - a6 = pears
cell range a7 - a8 = apples
AND
cell range d2 = green
cell range d3 - d5 = red
cell range d6 - d7 = green
cell range d8 = red

I would expect to have a returned count value of 3 records/rows where data
is "red apples".....make sense?

Thanks