software

I have calculated a sum using

=SUMPRODUCT((L2:L15000=2.5)*(N2:15000Ngt;=M11)*(P2:P 15000))

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: www.excelforum.com/member.php...oamp;userid=32086
View this thread: www.excelforum.com/showthread...hreadid=518668=SUMPRODUCT((L2:L15000=2.5)*(N2:15000Ngt;=M11))
will give you the number of rows meeting both criteriaquot;erik550quot; wrote:

gt;
gt; I have calculated a sum using
gt;
gt; =SUMPRODUCT((L2:L15000=2.5)*(N2:15000Ngt;=M11)*(P2:P 15000))
gt;
gt; How do I count the number of rows that fullfilled the criterias above?
gt; countif doesnt seem to accept more than one condition.
gt;
gt; /Erik
gt;
gt;
gt; --
gt; erik550
gt; ------------------------------------------------------------------------
gt; erik550's Profile: www.excelforum.com/member.php...oamp;userid=32086
gt; View this thread: www.excelforum.com/showthread...hreadid=518668
gt;
gt;


Great, thanks a lot!--
erik550
------------------------------------------------------------------------
erik550's Profile: www.excelforum.com/member.php...oamp;userid=32086
View this thread: www.excelforum.com/showthread...hreadid=518668