Help

SUM formula help

Topic Labels: Formulas
4806 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Tara_B
4 - Data Explorer
4 - Data Explorer

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

2 Replies 2
Andrew_Johnson1
8 - Airtable Astronomer
8 - Airtable Astronomer

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…