Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Oct 22, 2020 04:28 AM
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!
Oct 29, 2020 12:28 AM
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} +...