LinkBack URL
About LinkBacks
Attached file should be self-explanatory.
I want to be able to set sum range using lookup or match..
For example if I change B2 value to Nov-13, I want it to sum column K.
Thank you
Sumifs Range.xlsx
Attached file should be self-explanatory.
I want to be able to set sum range using lookup or match..
For example if I change B2 value to Nov-13, I want it to sum column K.
Thank you
Sumifs Range.xlsx
You could do it that way, but it would be an obtuse solution.
Can you use this instead:
B3:
=SUMPRODUCT(($G$3:$G$20=A3)*($H$3:$H$20=$E$19)*($I$2:$M$2=$B$2)*($I$3:$M$20))
and copied down
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
In B3 copied down
=SUMIF($G$3:$G$20,A3,INDEX($I$3:$M$20,,MATCH(B$2,$I$2:$M$2,0)))
Does that work for you?
Last edited by ChemistB; 02-07-2014 at 02:34 PM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Nice ChemistB. Never would have thought to use a nested INDEX.
So to get the Product ID, then:
=SUMIFS(INDEX($I$3:$M$20,,MATCH($B$2,$I$2:$M$2,0)),$G$3:$G$20,A3,$H$3:$H$20,$B$1)
and copied down
Thanks Daff
Thank you both! I need to tweak the formula some bit for the actual data but I got the idea..!
Last edited by inincubus; 02-07-2014 at 04:03 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks