I have calculated a sum using

=SUMPRODUCT((L2:L15000=2.5)*(N2:15000N=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: http://www.excelforum.com/member.php...o&userid=32086
View this thread: http://www.excelforum.com/showthread...hreadid=518668