Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

SUM formula help

Topic Labels: Formulas
3712 2
Showing results for 
Search instead for 
Did you mean: 

Is there a way to do a SUM formula that doesn’t just count the one record it’s attached to but includes previous ones? So like:
10 =SUM(A1)
15 =SUM(A1+A2)
10 =SUM(A1:A3)

So I can add a number into Column A and have a running total in Column B. In the example above it would Column B would read 10, 25, 35

2 Replies 2

This thread may help you out.

Unfortunately, trying to implement your example would trigger Airtable’s safeguards against circular references. That said, there are ways to get around this limitation, although they require [minimal] manual intervention. In an earlier post and demo base, I show how to create several different types of running totals. Admittedly, none is very pretty; on the bright side, you can often drop the provided routines into your base and henceforth forget about them…