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
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.