Add up of number whitch is seperate

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

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).

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.