Calculating and average between bases

1049 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast


I have multiple bases that need to remain separate and one primary base where I need to track the average of a ranking between the other bases. Is there a way to reference a specific value in each of these other bases and display the average? I’ve only been seeing posts and videos about how to calculate an average from different tables within the same base. Also is there a way to make this a weighted average?

Will I need to sync/copy these separate bases into the primary base to then calculate the average of the field?

Thanks in advance!

1 Reply 1

Hey Heidi,

Yes, you’ll need to sync the bases to one. You can then create formulas, rollups, and lookups to calculate the information.

Hannah - - Automated Backups for Airtable