I receive a sheet that has forecasts by part number by week in columns. I don't care about the weekly total, I just want to see it by month. I inserted a row using a "=MID" function to remove date and year so all I have left is the month(see attached in row 2). How can I group horizontally by month?
In B20 enter =SUMIF($B$2:$X$2,B$19,$B4:$X4) and drag down and across
SUMIF
Please see the attached file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks