LinkBack URL
About LinkBacks
Dear Guys
Trying to get YTD Sum based on multiple criteria using a drop down list.
The criteria are based on columns. Not really sure how to go about it. Appreciate any help.
Attached spreadsheet for reference. Thanks in advance guys!
Ben
Dear Guys
Trying to get YTD Sum based on multiple criteria using a drop down list.
The criteria are based on columns. Not really sure how to go about it. Appreciate any help.
Attached spreadsheet for reference. Thanks in advance guys!
Ben
Can you tell which row has the YTD Sum?
Cheers!
Deep Dave
Hi Dave
Row 8 (Sent). Thanks!
Now for example, FEBRUARY & BRAND 1 have occurred twice, do you want total of both?
181774 + 181774??
If yes then try this in Cell C8
=SUMPRODUCT(IF((C3='DATA ENTRY'!A3:J3)*(SUMARY!C4='DATA ENTRY'!A4:J4)=1,'DATA ENTRY'!A8:J8,""))
Commit using Ctrl+Shift+Enter
Thanks Dave, however once I selected FEBRUARY, it didnt sum YTD amount.Originally Posted by NeedForExcel
If selected FEBRUARY, YTD will cover JAN-FEB...
So if you select Feb and Brand 2 for instance, it should add up values for Jan & Feb, but only for Brand 2? Is this right?
Yes, Dave thats correct. Thanks.
Try this in c8 on Summary Sheet.
Make sure you unmerge cells before applying the formula.
=SUMPRODUCT(IF(INDIRECT("'DATA ENTRY'!$C$4:"&ADDRESS(4,LOOKUP(2,1/(SUMARY!C3='DATA ENTRY'!C3:H3),COLUMN('DATA ENTRY'!$C$3:$H$3))))=SUMARY!C4,INDIRECT("'DATA ENTRY'!C8:"&ADDRESS(8,LOOKUP(2,1/(SUMARY!C3='DATA ENTRY'!C3:H3),COLUMN('DATA ENTRY'!$C$3:$H$3)))),0))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
See the file attached.
Last edited by NeedForExcel; 04-18-2016 at 07:07 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks