Help in Sumproduct and reference formulas

P

peter.abing

New member
Joined
Oct 24, 2012
Messages
34
Reaction score
0
Points
0
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,
PeterView attachment Sample.xls
 
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))
 
Fotis1991 said:
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))
Click to expand...

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!
 
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)))
 
You are welcome.

Thanks for the feed back.

@ Bob.

Now i have 5 posts! i'll do(provide link for cross posting) alone!:smile:
 
You must log in or register to reply here.
Back
Top