Vlookup between 2 tables and return sum total

[Nedra_Hines]

I have 2 tables: “Home Staging Projects” and “Inventory Items”. In the “Home Staging Projects” table, I want to vlookup on the “Project ID” and return the sum total of “Rental Price” for each inventory item selected for that project listed on the “Inventory Items” table. I hope that makes sense.

I’m not sure if this makes a difference, but the “Inventory Items” table is linked to the “Home Staging Projects” table by (formula) “Project ID”.

Is there a way to use a formula for this?

[Sho]

If they are linked, then the Rollup field can be used.

Rollup Field - Overview | Airtable Support

[Nedra_Hines]

I looked at both Rollup and Lookup and didn't see how to make it work.

[Sho]

Add a Rollup field to "Home Staging Projects" table

 Can you set it up like this?

[Nedra_Hines · Accepted solution]

OMG IT WORKED!!!! THANK YOU SO MUCH! I wouldn't have ever thought of that, and I've watched several Youtube videos to figure this out. I really appreciate it so much.