SUM formula help

[Tara_B]

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:
A B
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

[Andrew_Johnson1]

This thread may help you out.

How to create a running total or balance Apps

I’m not able to find an Airtable example of a simple checkbook register. Balance = Previous Balance - Debit + Credit. How would you do that in Airtable?

[W_Vann_Hall]

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…