Using Count Formula

[Dirkelton]

I'm desperatly after help!!

I'm trying to count the number of rows based on criteria in 2 different columns. For Example If column A = 1, and Column B <=48 then count number of Rows.

I've been playing with sumproduct and count, Countif etc but getting nowhere

 

[Jonmo1]

Welcome to the board...

Sumproduct is the way to go..

Try

=SUMPRODUCT(--(A1:A100=1),--(B1:B100<=48))

 

[Dirkelton]

Thanks, works perfect.

I can see this being the first of many........

 

[Dirkelton]

How would this work if the second criteria was >=48 & <60 for example?

 

[sanrv1f]

Just extened the formula,

=SUMPRODUCT(--(A1:A100=1),--(B1:B100>=48),--(B1:B100<=60))

<!-- / message --><!-- sig -->

 

[Dirkelton]

Thank you