I am trying to count the values of a cell range based on two different cell
ranges containing certain data.

For example:
cell range a2 - a4 contains apples
cell range a5 - a8 contains pears
cell range a9 - a10 contains apples
and cell range d2 - d7 contains red
and cell range d8 - d10 contains green

count cell range d2-d10 that has a value of red AND cell range a2-a10 has a
value of apples and return a value of 5 (5 records/rows have a value of
apples and red)

Does this make sense?

Thanks