Need a Formula to turn daily data into a monthly summary for gross revenue

**mikavelli17** · 10-24-2012, 08:25 PM

So I need a formula that will sum daily data into monthly totals for multiple websites.

I need the data to display in a table with the columns being the month and year and rows being gross revenue broken down by each website.

Tried many SUMIFs and was close but nothing seemed to work.

Thanks for any help!

**MarvinP** · 10-25-2012, 01:55 AM

Hi mikavelli17 and welcome to the forum,

This looks like a job for Pivot Tables. See the attached where I've spent about 1 minute making a PT of your data. There are so many possibilities to format the data, I don't know what makes sense for you. See if it helps. Look at grouping in Pivot Tables....

**mikavelli17** · 10-25-2012, 12:19 PM

Thanks for looking into it. The reason I avoided a pivot table was bc we are trying to keep the size of the file small. Am I mistaken that pivot tables are larger than just using a formula? I want to be able to look at multiple years worth of data, any suggestions for keeping the file size small?