Results 1 to 4 of 4

Aggregate weekly data by by another condition from daily data

Threaded View

  1. #1
    Registered User
    Join Date
    11-18-2010
    Location
    SLC, UT
    MS-Off Ver
    Excel 2007
    Posts
    2

    Aggregate weekly data by by another condition from daily data

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1