Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How can I perform a calculation from the values that were returned in a lookup field

Topic Labels: Formulas
Solved
Jump to Solution
353 1
cancel
Showing results for 
Search instead for 
Did you mean: 

So I’m not sure how to ask it differently, but if I were to try, here it goes.

NEW to Airtable (so TY for being patient & detailed)

So I have a base with three tables in it, Customers, Vehicles & Sales. I’m trying to collect all of the sales for each customer. All of the tables are linked, and I have been able to bring each of the sales into one cell (example: $0.00, $170.00, $125.00). But now I need to total those numbers!

Any help would be greatly appreciated!

DG

1 Solution

Accepted Solutions

Welcome to the Airtable commumity.

Try using a rollup field instead of a lookup field.To get the sum of the values, use the rollup formula SUM(values)

See Solution in Thread

1 Reply 1

Welcome to the Airtable commumity.

Try using a rollup field instead of a lookup field.To get the sum of the values, use the rollup formula SUM(values)