How to sum up a range of fields (Column A→X) from one record instead of manually adding each?

Topic Labels: Formulas
3282 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am trying to summarize a range of fields from one record. I know that there is a formula Sum({Column 1}+{Column 2}+{Column 3}…). However, I am looking for a formula to choose all the columns between Column A → Column X. I will have a database with many columns and I need to summarize multiple records quickly.

Is there any formula that can help?
Or what are the possible solutions for this?

This is an example

Thanks for any help!

1 Reply 1

Hi @Uliana - there isn’t a way to do this in Airtable I’m afraid - you can’t do the Excel-style formula of


You will need to explicitly set up your Sum field to be:

{Field A} + {Field B} +...