Help

How do you sum a column of data

Topic Labels: Formulas
Solved
Jump to Solution
5860 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Vijay_chen
6 - Interface Innovator
6 - Interface Innovator

How do you sum a column of data.
I try the formulas that SUM({GROUP}), but the result is not the sum of all the data in a column.

1 Solution

Accepted Solutions

[Can’t] formulas act on one column at a time?

Formulas are run once per row. During that runtime, they have access to values in other columns of that row, but they have no idea what data other rows have.

It’s technically possible to put a row reference inside of another row… that’s what a linked record fields is, as well as the fields that make use of linked records. Guessing those won’t help in this case, but they might in others.

[Can] summary bar data [be referenced in] formulas?

Unfortunately no. But the summary bar can combine row data. It also works for grouped data (portions of a column). For example, grouping by month:

Screen Shot 2020-07-16 at 9.53.56 AM

If you need to do more complex math (that breaks all of these rules) the scripting block runs JavaScript. But you may want to hire a developer for that if you’re not familiar. Best of luck.

See Solution in Thread

5 Replies 5
Zollie
10 - Mercury
10 - Mercury

Formulas only act on one row at a time. But you could use the summary bar.

Thanks Zolie, Airtable can not formulas act on one column at a time? I need to calculate the proportion of a data in the sum of a column of data, so I need to calculate the sum of a column of data. Or may I ask if the summary bar data can be quoted in the formulas?

[Can’t] formulas act on one column at a time?

Formulas are run once per row. During that runtime, they have access to values in other columns of that row, but they have no idea what data other rows have.

It’s technically possible to put a row reference inside of another row… that’s what a linked record fields is, as well as the fields that make use of linked records. Guessing those won’t help in this case, but they might in others.

[Can] summary bar data [be referenced in] formulas?

Unfortunately no. But the summary bar can combine row data. It also works for grouped data (portions of a column). For example, grouping by month:

Screen Shot 2020-07-16 at 9.53.56 AM

If you need to do more complex math (that breaks all of these rules) the scripting block runs JavaScript. But you may want to hire a developer for that if you’re not familiar. Best of luck.

Zolie, thanks for your answer :thumbs_up: . I know more about Airtable now

Sure thing. Maybe mark one of them as the solution?