I am new to this forum so please forgive me... I do think this question will add good information to the community.
The title may be a bit confusing, but here is my problem:
I have marketing data by channel by day and I would like to aggregate it by week by channel. Column B has the Dates, Column C has the channels, and Column D has the revenue data. Each day there is a revenue number associated with each channel.
I have attached an example file with the daily data and the weekly output format. I assume that using a combination of if and sumif or a sumproduct would work but I do not have much experience with sumproduct. This problem is giving me trouble because I want to sum data based on 2 conditions. I know a pivot table is designed to solve this problem but I would like to avoid this because I will have many different data sets that I will have to organize every week.
I have searched all over and have not found a similar problem with the daily data organized like mine.
Any help would be greatly appreciated. Thanks!
Bookmarks