Solved

Summing Weekly Sales Totals

Posted on 2014-11-29
2
104 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Google Sheets Script 21 57
Excel Save As Status Box will not go away 6 19
excel help 4 19
Autofit all columns of all worksheets using VBA 14 0
Outline Suppose you have some simple text based data in Excel that you would like to display as a PowerPoint presentation. Of course it would be possible to write some fairly complex VBA code that created a new slide for each line of the Excel data…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

895 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

19 Experts available now in Live!

Get 1:1 Help Now