ExcelBanter - countif

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - countif (https://www.excelbanter.com/excel-discussion-misc-queries/75065-countif.html)

erik550

countif

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

countif

=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: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

erik550

countif

Great, thanks a lot!

--
erik550
------------------------------------------------------------------------
erik550's Profile: http://www.excelforum.com/member.php...o&userid=32086
View this thread: http://www.excelforum.com/showthread...hreadid=518668

All times are GMT +1. The time now is 04:34 PM.