Help

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.

Add up of number whitch is seperate

Topic Labels: Formulas
324 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello there,
I would like to add up number like this :
142.10,42,21.20

The result I want is 205.30

I don’t know how to transform the cell to an array and add up each line of the array

Thx for your help

1 Reply 1

Unfortunately you can’t manually build arrays in Airtable. Arrays are only created by certain field types (primarily lookup and rollup fields), and even there Airtable’s array processing functions are very limited.

If the fields containing those values are in a single record, you can use the SUM() function:

SUM({Field1}, {Field2}, {Field3})

This won’t work between records because of Airtable’s database-like behavior. Records can’t directly reference other records without being linked. If you’re looking to tally the values across several records, would you mind sharing more details about your use case? There may be other ways to pull it off, but knowing about the design of your base will help us to offer the most appropriate solution(s).