Nested Subtotal Formula

[nickimu]

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

 

[Duke Carey]

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