count if

C

cletabujol

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...
 
B

Bob Phillips

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)
 
Top