using sumproduct on subtotals meeting certain conditions

J

Jeff Manning

How to sum all the negative subtotals on a detailed data list:

Col A Col B Col C
customerA inv1 100
customerA inv2 100
customerA inv3 -100
customerB inv1 100
customerB inv2 -200
customerC inv1 -100

If I subtotal by customer, I get:
customerA 100
customerB -100
customerC -100

I would like to summarize only the negative subtotals (result -200)

What would the formula be to accomplish this?
 

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

Top