Forum Discussion
value match and get sum only negative values
Hi,
I need to get a match SKU Description and take only the sum of negative values from monthly colums in the sheet of order requirement
2 Replies
- monthly columns are the ones with months names, or related BF, or both?
- in your tags are Excel mobile, Online, Mac, O365, for which exactly platform would you like the solution?
- another tag is Macros and VBA, does that mean you prefer VBA solution for the platform where VBA is available?
Does this do what you want? In C2, enter
=SUMPRODUCT('ORDER REQUIREMENT'!$H$2:$AE$42,('ORDER REQUIREMENT'!$C$2:$C$42=A2)*('ORDER REQUIREMENT'!$H$2:$AE$42<0))
Fill down.
