"Bill Kuunders" wrote in message
...
=SUMPRODUCT((B17:B20="xxx")*(OR(F17:F20="yyy,yyy,y yy",F17:F20="yyy"))*(G17:G20<"zzz"))

seems to work for me

If it works for you then that is fine but it doesn't work for me. I don't
think that OR works in a SUMPRODUCT function.

When I enter xxx in B17:B20, zzz in G18 & G20 and just z in G19 then if I
put yyy in ANY cell in F17:F20 the formula return 2.

In other words the OR is making the yyy apply to all cells in F17:F20

The "+" in the formula I posted works like an OR but I see that I forgot to
eliminate the zzz in column G so it should have been:

SUMPRODUCT((B1:B30="xxx")*((F1:F30="yyy1")+(F1:F30 ="yyy2")+(F1:F30="yyy3"))*(G1:G30<"zzz"))


--
HTH

Sandy

with @tiscali.co.uk

"Bill Kuunders" wrote in message
...
=SUMPRODUCT((B17:B20="xxx")*(OR(F17:F20="yyy,yyy,y yy",F17:F20="yyy"))*(G17:G20<"zzz"))

seems to work for me

--
Greetings from New Zealand
Bill K
"pinmaster" wrote in message
...
Not sure I understood the part about the F column but try this:

=SUMPRODUCT((B1:B10="xxx")*OR(F1:F10="yyy,yyy,yyy" )*OR(F1:F10="yyy")*(G1:G10<"zzz"))

HTH
JG

"telewats" wrote:


I am trying to determine the total count of cells containing certain
data, and I can't get my formula to work correctly. I need to get the
total number of cells that fit the following criteria: If column B
contains xxx, and column F is equal to yyy, yyy, yyy, or yyy, and
column G is not equal to zzz, then count the cells. I'm sure this can
be done (right?) but I am not having any luck.


--
telewats
------------------------------------------------------------------------
telewats's Profile:
http://www.excelforum.com/member.php...o&userid=30270
View this thread:
http://www.excelforum.com/showthread...hreadid=503018