Help in Sumproduct and reference formulas

[peter.abing]

Hi,

I have a simple problem with excel. I know that it is possible but I just don't know how.
Could you please help?

It's mainly a referencing problem.
Please see attached.

Thanks,
PeterSample.xls

[Fotis1991]

Perhaps something like this?

In K3 and copy down and across.

=SUMPRODUCT(($A$2:$C$2=$J3)*($A$3:$C$11)*(E$3:E$11))

[peter.abing]

Perhaps something like this?

In K3 and copy down and across.

=SUMPRODUCT(($A$2:$C$2=$J3)*($A$3:$C$11)*(E$3:E$11))

Thank you so much. It works.
At first I was in doubt because the result is not the same with my sample. It turns out that my sample is wrong since the header (column numbers) were included in the sumproduct function.

Thank you so much.

Great help!

[Bob Phillips]

Or

=SUMPRODUCT(INDEX($A$3:$C$11,0,MATCH($J3,$A$2:$C$2,0)),INDEX($E$3:$H$11,0,MATCH(K$6,$E$2:$H$2,0)))

[Fotis1991]

You are welcome.

Thanks for the feed back.

@ Bob.

Now i have 5 posts! i'll do(provide link for cross posting) alone!

[Bob Phillips]

Now i have 5 posts! i'll do(provide link for cross posting) alone!

So you just ditch me