![]() |
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