Summing Weekly Sales Totals

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
Cactus1994OwnerAsked:
Who is Participating?
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Assuming D7 is meant to be the same as A7, then

=Sumifs(c:c,a:a,">"&(d7-7),a:a,"<="&d7)
0
 
Cactus1994OwnerAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.