Trying to complete a SUMIF that looks up the matching item number in a column, then sums up all the values that match the date range for each month at a time, but the dates are actual column headers. I don't trust PIVOT TABLES when it comes to dates.My 800th formula try is in cell E3.
Any suggestions?
Thanks.
=SUMIFS('SALES-GRR'!H2:BM5441,'SALES-GRR'!B2:B5441,$X$1,'SALES-GRR'!H1:BM1,">="&DATE(2013,1,1),'SALES-GRR'!H1:BM1,"<="&DATE(2013,1,31))
Using your posted workbook...
This regular formula, copied across, sums the number of orders for a specific item by month
Formula:
Please Login or Register to view this content.
Is that something you can work with?
That seems to work just great, and will stick with moving dates throughout the year.
Thanks so much, appreciate the quick solution!!!
Another question. How would I protect a month in 2013 from a month in 2014. I have DEC orders that are not filled yet, as well as new 2014 DEC orders
Last edited by Prodschdler; 10-25-2013 at 11:26 AM. Reason: Didn't push the new question, was double post.
Change the column headings from MMM to YYYYMMM (DEC to 2014DEC)
Then use this formula:
Formula:Please Login or Register to view this content.
Does that help?
Perfect, thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks