count if
 

how do i get the count if function to count based on certain concrete
conditions...if cell a1 = condition a and <= condition b then add 1
to count...

count if
 

single cell

=IF(AND(A1=condition_a,A1<=condition_2),1,0)

range of cells

=SUMPRODUCT(--(A1:A10=condition_1),--(A1:A10<=condition_2))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
oups.com...
how do i get the count if function to count based on certain concrete
conditions...if cell a1 = condition a and <= condition b then add 1
to count...