How to Calculate a Running Total of Daily Receipts in Excel

Open your Excel workbook (.xlsx) in Cue Office. Use SUM to add the amounts from the first day through the current row, then fill the formula down. Each row shows how much you received through that day, so you can check the amounts one day at a time.

Match each running total to that day’s receipts

Start by sorting your receipts by date. In the sample worksheet, column A lists the days of the week, and column B, Received, logs daily receipts. Because values begin in B2, enter Running total in C1, and then enter the formula below into C2.

=SUM($B$2:B2)

$B$2 keeps the sum anchored to cell B2. If you change the amount in B2, the totals recalculate. The B2 after the colon changes with each row. In C3, the formula becomes =SUM($B$2:B3), which adds Monday’s and Tuesday’s receipts. After entering the first formula, select C2:C6.

The Name Box shows C2:C6, the formula bar displays =SUM($B$2:B2), and the worksheet shows full day names and the selected range
The Name Box displays C2:C6, while the formula bar continues to show the formula from the first cell, C2.

On the Home toolbar, open Fill and choose Fill Down to copy the C2 formula down the selection.

On the Home ribbon, the Fill menu next to Sort & Filter is expanded with Fill Down as the first option
Fill is located to the right of Sort & Filter. The first option in the dropdown is Fill Down.

How to Verify the Running Total

Save and reopen the workbook in Cue Office. The log shows 25 for Monday and 40 for Tuesday, so Tuesday’s running total should be 65. With no receipts on Wednesday, the total stays at 65. By Friday, it reaches 120.

After reopening the manual workbook, the five-day running totals display 25, 65, 65, 100, and 120
After reopening the workbook, read the five daily running totals in column C.

Have Cue AI Fill the Running Total Column

Open a copy of the original data. On the Home toolbar, click Cue AI and ask it to fill in the running totals in column C.

The Cue AI button on the Home ribbon and the open sidebar
After opening Cue AI, submit your prompt in the sidebar.
I'm tracking how much we've received by the end of each day. Could you fill C1:C6 on Sheet1 with a Running total column that updates whenever I change a Received amount? Please leave columns A and B as they are.

After Cue AI writes the formulas, close the sidebar, save the workbook, and reopen it in Cue Office. Check that columns A and B match the original and that C2:C6 shows 25, 65, 65, 100, and 120. In this example, Cue AI wrote =C5+B6 in the last row. It adds Friday’s receipts to Thursday’s running total.

In the AI copy reopened in Cue Office, the five-day running totals display 25, 65, 65, 100, and 120
After reopening the AI copy, the five-day running totals match the manual calculation.

To check that the totals update, change Wednesday’s amount in B4 from 0 to 10 in a separate test copy. Monday and Tuesday should stay at 25 and 65. Wednesday through Friday should now read 75, 110, and 130.

Practice with a Five-Day Donation Log

Show the full example

Community volunteers record daily contributions and want to know the cumulative funds raised before wrapping up on Friday. Copy the table below, paste it into A1 of Sheet1, and follow the steps above to populate column C.

Day	Received
Monday	25
Tuesday	40
Wednesday	0
Thursday	35
Friday	20

From Monday through Friday, C2:C6 should show 25, 65, 65, 100, and 120 in sequence.

How to track down a 10-unit difference in Friday’s total

Subtract the previous day’s running total from the current day’s total to see how much the sheet records for that day. Wednesday’s 75 minus Tuesday’s 65 gives 10. Check Wednesday’s receipts. If nothing came in that day, change B4 back to 0 and check that Friday’s total returns to 120. If you have more days to add, enter the amounts received, then give Cue AI the first and last new row numbers and ask it to extend the running total. Subtract the old last total from the new one and check that the difference equals the sum of the new receipts.

For the weekend handoff, use the free Cue Office app to edit your Excel (.xlsx) donation log and open PDF (.pdf) receipts to check any amounts in question. Add the verified total to your Word (.docx) handoff notes or update the PowerPoint (.pptx) fundraising report for volunteers.

Download Cue Office for free