Help in Sumproduct and reference formulas

peter.abing

New member
Hi,

I have a simple problem with excel. I know that it is possible but I just don't know how.

It's mainly a referencing problem.

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

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!

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:

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

So you just ditch me