Nested Subtotal Formula

  • Thread starter Thread starter nickimu
  • Start date Start date
N

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nesting SUBTOTAL with SUMPRODUCT? 0
Subtotal of values in cells containing formula 1
subtotal with sumif nested 1
Subtotal and Auto-filter 2
Countif help needed 6
Formula Count dates multiple criteria 3
Subtotal 4
Use dynamic column reference without R1C1 3

Back
Top