Skip to main content

Hi!

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!

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


=sum(A1:C1)


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


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

Hi, the above post was a long time ago. Is airtable still not able to sum an adjacent range of fields, with specified start and end as per the excel formula above? thanks

Reply


Terms & Conditions