countif

[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

[bj]

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


"erik550" wrote:

>
> 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
>
>
> --
> erik550
> ------------------------------------------------------------------------
> erik550's Profile: http://www.excelforum.com/member.php...o&userid=32086
> View this thread: http://www.excelforum.com/showthread...hreadid=518668
>
>

[erik550]

Great, thanks a lot!