Hi,
I have multiple sum range colums with multiple look-up criteria. I tried using Sumifs to fix it but its not helping. Please lookinto this.
Hi,
I have multiple sum range colums with multiple look-up criteria. I tried using Sumifs to fix it but its not helping. Please lookinto this.
Hi
In M3 and copy down and across.
Formula:Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi,
=SUMPRODUCT(($D$2:$J$2=$L3)*($B$3:$B$16=M$2)*$D$3:$J$16)
Regards
Try this.......
In M3
and then drag across and down.Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks