[...]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.
Aladin Akyurek said: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)))
force530 said: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 said: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)))
It just doest seem to recognize the "filed-arrest felony"
:
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"})))
:
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)))
Aladin Akyurek said:You need 0 in the second MATCH too...
=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"},0)))
It just doest seem to recognize the "filed-arrest felony"
:
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"})))
:
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)))