sumproduct with multiple crieria

[desert rat]

I am using this SUMPRODUCT to find numbers >=10


=SUMPRODUCT(--(N2:N236>=10),SUBTOTAL(103,OFFSET(N2,ROW(N2:N236)-ROW(N2),0)))


any ideas how i can modify this so that it counts only the data cells that are >=10 and <=12


Cheers

 

[NARAYANK991]

Hi ,


Generally , having multiple conditions as criteria is taken care of by multiplying the conditions as follows :


At present , you have one condition (N2:N236>=10).


If you want to have two conditions , use : (N2:N236>=10)*(N2:N236<=12)


You can add more conditions in this manner.


Narayan

 

[desert rat]

Awesome. Thanks again mate!