# Look up and sum daily data to weekly summary

1. ## Look up and sum daily data to weekly summary

My predecessor has been manually entering sum formulas for each expense category in each week. I'd like to use a formula which can be copied across the rows to pull the daily data into a weekly summary. I can't imagine this is too difficult. I'm just don't have enough Excel experience to figure it out.

2. ## Re: Look up and sum daily data to weekly summary

What specifically you looking for? Those SUM formulae seems OK.

3. ## Re: Look up and sum daily data to weekly summary

Since I have multiple rows of information going across 52 weeks, I'd like to automate the formula so it can be copied to each week without having to enter the specific rows of data to sum for each week.

4. ## Re: Look up and sum daily data to weekly summary

Looks like Pivot Table is what you looking for.

5. ## Re: Look up and sum daily data to weekly summary

In "Weekly Cash Flows"

in C5

=SUMIFS('Daily Cash Flow'!\$C:\$C,'Daily Cash Flow'!\$A:\$A,">="&C\$2,'Daily Cash Flow'!\$A:\$A,"<="&C\$3)

In C6

=SUMIFS('Daily Cash Flow'!\$D:\$D,'Daily Cash Flow'!\$A:\$A,">="&C\$2,'Daily Cash Flow'!\$A:\$A,"<="&C\$3)*-1

Copy both across

Repeat for other entries, changing the first range (highlighted in bold)

6. ## Re: Look up and sum daily data to weekly summary

Perfect! Thank you, Mr. Topley!

7. ## Re: Look up and sum daily data to weekly summary

Thank for the feedback and rep.

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

#### 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