=SUMPRODUCT(--(F2:F46="RED"),--(E2:E46="SMALL"))
should work

--
Greetings from New Zealand
Bill K

"davmason" wrote in
message ...

I am trying to count data entries under two conditions - ie. if it is
red and small count it, .
p.s. I am extracting data from the sheet "data" to a smaller "results"
sheet.

I have tried this formula and can't see why it doesn't work!!??.
=IF(AND(DATA!F2:F46=\"RED\",DATA!E2:E46=\"SMALL\") ,COUNTA(DATA!E2:E46),\"
\")

why will this not work????
*any* advice is appreciated
thanks in advance
Dave


--
davmason
------------------------------------------------------------------------
davmason's Profile:
http://www.excelforum.com/member.php...o&userid=25292
View this thread: http://www.excelforum.com/showthread...hreadid=387796