countif

E

erik550

I have calculated a sum using

=SUMPRODUCT((L2:L15000=2.5)*(N2:15000N>=M11)*(P2:p15000))

How do I count the number of rows that fullfilled the criterias above?
countif doesnt seem to accept more than one condition.

/Erik
 
B

bj

=SUMPRODUCT((L2:L15000=2.5)*(N2:15000N>=M11))
will give you the number of rows meeting both criteria
 
Top