Mike,

Thanks for the help, I tried editing that function to my needs but then I
got some errors, also I found I need 1 or 2 more constraints, here's a
similar example of what I need:

IF F:F=000, G:G=AA and K:K=5 then COUNT how many H:H are between 5 and 7
(including 5 and 7)

I hope this can be done with functions.

Thanks.

"Mike H" wrote:

try

=SUMPRODUCT((B1:B10<=5)*(C1:C10=E5)*(A1:A10=1))+SU MPRODUCT((B1:B10<=5)*(C1:C10=E5)*(A1:A10=2))

Mike

"ivera" wrote:

Hey guys,

This is something I need for my work. Ive been trying to get around it but
can't seem to make it work.

I need to know how many people are in Column A are from range =1 <=2 if
Column B is <=5 all this if Column C=E5 (just an example).

Thanks.