Hi,
I am trying to take a list of specific revenue categories with daily revenue #s in them and sum the numbers by month based upon each category in a separate section on the worksheet. Thank you for the assistance and let me know if you have any questions and attached is the file
Sum of Dates by category.xlsx
Hi usc1382
I had to reformat your data on sheet2 and then do a pivot table on it. I have also included a Macro that does the reformatting. See the attached.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks