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!