Grouping Dates into Months
I know this is probably going to be a really easy answer, but my brain is fried at work... I have a table with model numbers as column A, and Row 1 contains dates, each columns contains net sales, my question is there any simple way to group all dates into months and years, i have tried using a pivot and it doesnt work correctly, any help?
Screenshot (1).png
If I understand what you are saying the attached sheet might be what you want.
Yes it will. we just have to figure out how...
If I have helped you, PLEASE click the * and add to my Rep.
Also, if the problem is SOLVED please mark it as so.
In B10
=SUMIFS(2:2,$1:$1,">="&B$9,$1:$1,"<"&C$9)
drag this down and right
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks