Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Summing From Tables

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

Hi, I have a database set up with multiple tables.
Set up like this
Person1 (Information in one table) gets 5 Linked Entries in another table
How can I get these linked records to sum in the table with the first table

1 Reply 1

Hi there!

Not sure what you’re trying to sum up, but…

If you only want to count how many linked records there are for a particular person, you can use the Count field type. Otherwise, you’ll likely want to use a Rollup field.

Add a field on the first table, point it at the field on the second table that you want to sum up, then use the formula:

SUM(values)

Hope that helps!