Sumproduct with multiple criteria

[aarti_rto]

Hi,

I have below data..and need sumproduct in such a way that if RM PO price is greater than 0 sumproduct must include plan inward * RM PO Price and if RM PO price is less than 0 sumproduct must include plan inward * FG PO Price

in below data sumproduct calc should - sumof ( (0.76*1000)+(0.59*2000)+(32.67*1000)+(25.27*2000)+(2*3000)).please suggest how to do this in sumproduct formula or is there any other formula?

FG PO price	RM PO Price	Plan Inward
0.760	0.00	1000​
0.590	0.00	2000​
0.000	32.67	1000​
0.000	25.27	2000​
1.000	2.00	3000​

 

[steve the fish]

This would do it i believe:

=SUMPRODUCT(--(((B2:B6>0)*B2:B6)+((B2:B6<=0)*A2:A6)),C2:C6)

 

[aarti_rto]

thanks,
why you used -- in this formula,asking just to understand

 

[steve the fish]

Looking at it probably wasnt required in this instance. It will convert a TRUE/FALSE result into a 1 or 0 result.

 

[aarti_rto]

thank you