Sum Product Help Required‏

[kate.middleton1]

Hello Everybody

I need help regarding the Sum Product formula. For the sake of example the workbook is attached with this thread.

Thanks & Regards

[wfm007]

Use following function:

Please Login or Register  to view this content.

[kate.middleton1]

Hello
Thanks for your help.
Actually currently i am using excel 2003. In excel 2003 Sumifs does not works. Is there any replacement of Sumifs for excel 2003?

[Fotis1991]

Perhaps.

=SUMPRODUCT(--($D$11:$D$21=$H$12);$E$11:$E$21;$F$11:$F$21)/SUMPRODUCT(($D$11:$D$21=H12)*($E$11:$E$21>0)*($F$11:$F$21))

[kate.middleton1]

works perfect thanks for your help.

[wfm007]

Sorry for that

Please Login or Register  to view this content.

[Fotis1991]

works perfect thanks for your help.

.........................