![]() ![]() As you can see, we already have a running total that includes the previous 10 days of sales data for each row. Here's an example of a spreadsheet that we'll use to build a formula to do what we need. With this calculation, the sales figure will vary each day, depending on the sales made in the previous 10 day period. the first value in the table.This time, we want to calculate a running total for a given date period. We've already covered how to create a running total in Excel (all links in this lesson open in a new tab)$, but that lesson assumed that the running total always has the same starting point, i.e. ![]() An example might be calculating a running total of sales for the last 30 days, although you could use any date range you like, including future dates. This lesson shows you how to calculate a running total for a table of data that based on the dates in the table.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |