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))
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
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))
Regards
Fotis.
. Array(CSE) { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
. -Replace commas ( , ) with semicolons ( ; )-or vice versa in formulae, if your locale setting demands.
.--Don't attach a screenshot--Just attach your Excel file!
.--KISS(Keep it simple Stupid)
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!![]()
Regards
Fotis.
. Array(CSE) { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
. -Replace commas ( , ) with semicolons ( ; )-or vice versa in formulae, if your locale setting demands.
.--Don't attach a screenshot--Just attach your Excel file!
.--KISS(Keep it simple Stupid)
Bookmarks