=sumproduct(--(a1:a1000=13),--(r1:r1000="PRODUCE"),N1:N1000)

"nickimu" wrote:


Could someone help me debug the following formula?

=SUBTOTAL(9,IF(AND(A:A=13,R:R="PRODUCE"),N:N,0))

I am trying to add together numbers in column "N", if column "A" is 13,
and column "R" is PRODUCE.

Thanks for any help!


--
nickimu
------------------------------------------------------------------------
nickimu's Profile: http://www.excelforum.com/member.php...o&userid=26793
View this thread: http://www.excelforum.com/showthread...hreadid=400436