Really need to do this!
 

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.