ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   using sumproduct on subtotals meeting certain conditions (https://www.excelbanter.com/excel-worksheet-functions/54691-using-sumproduct-subtotals-meeting-certain-conditions.html)

Jeff Manning

using sumproduct on subtotals meeting certain conditions
 
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?



All times are GMT +1. The time now is 07:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com