Thanks for the reply ...

Okay here is the actual formula ... It will not add the "Filed-Arrest
Felony" when entered. The formula is accepted, but wont add the last part.

=SUMPRODUCT(--ISNUMBER(MATCH('OFFENSE LOG'!$F$7:$F$57,{"Murder","Capital
Murder"},0)),--ISNUMBER(MATCH('OFFENSE LOG'!$P$7:$P$57,{"filed-at large
felony","filed-arrest felony"})))


"Aladin Akyurek" wrote:



force530 wrote:
[...]
These are the conditions; If Column A has
either apples and/or grapes I would like them to be counted only if oranges
or pears are in the same row in column B. i.e., A5=apples or grapes and B5=
oranges or pears, then the condition is met and it should reflect 1.
[...]

=SUMPRODUCT(--ISNUMBER(MATCH($A$2:$A$10,{"apples","grapes"},0)),--ISNUMBER(MATCH($B$2:$B$10,{"oranges","pears"},0)))