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