countif

[erik550]

I have calculated a sum using

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

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

/Erik

 

[Guest]

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

 

[erik550]

Great, thanks a lot!