Solved

Summing Weekly Sales Totals

Posted on 2014-11-29
2
106 Views
Last Modified: 2014-11-30
I have attached a spreadsheet of daily revenue totals. Our week runs Monday through Sunday. Next to each "Sunday Date" I want to return the week's total.

For example, in cell E7 I would like a formula to return a total of $1,317.06. In cell E8, I would like it to return $5259.89, and so on.

Please, no pivot tables, data tables, or arrays. I just need a formula to return the summed data.

Thanks in advance!
Weekly.xlsx
0
Comment
Question by:Cactus1994
2 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40472280
Assuming D7 is meant to be the same as A7, then

=Sumifs(c:c,a:a,">"&(d7-7),a:a,"<="&d7)
0
 

Author Closing Comment

by:Cactus1994
ID: 40472300
Phillip:

Your assumption was wrong, but your formula was perfect.

D7 is not meant to be the same as A7 ... column A is for every day of the year and corresponding sales, where column D is only the Sunday dates, which end our workweek, and next to which the weekly totals should be summed and appear.

Thanks!
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now