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 do i total a column

850 4
Showing results for 
Search instead for 
Did you mean: 

Hello there is some way to totalize an entire column in another column or in a cell.
Thank you very much


4 Replies 4

Hey there! This is a great question, and actually requires a little workaround, which basicalically involves you creating a new table, and using the lookup field.

I’ve created one here for you:

As you can see, I created a record called “sum” and applied that to all of the records. So now I can use that value elsewhere.

Hope that helps!

Perfect, that’s exactly how I need it,
Can you do me a favor and explain how to do it?
Thank you

If you look at the hidden field, you can see a “SUM” Linked Field. Which I’ve added and linkedall to a running totals table.

Then I’ve done a lookup of the SUM again in the totals field.

There’s a support article out there on this too, I think, as I remember that’s how I learned about this workaround.

Thank you very much for your help.