Rollup or Sum in Sheet B of Numbers in Sheet A (when name matches)

[emilyebrooks]

Hi all! 
I am attempting to utilize data from "Sheet A" (specifically item names and quantities) and SUM the "Quantity" in "Sheet B" when the "item name" from Sheet A matches the "item name" from Sheet B. 

Is this possible in Airtable? I've played around with a few different formulas and field types but none have successfully produced what I'm looking for. I've also created a grouped view in Sheet A that groups by Item Name and it shows the Sum in that view if that helps.

If possible, I would prefer for it to be a clean formula/rollup/link/or just about any other method than manually looking up the info from one sheet and keying it into another. 

To clarify - all of this information is housed in one Base just multiple sheets.

Any assistance is appreciated! 
 

[TheTimeSavingCo · Accepted solution]

Hmm, assuming you've got a link between the two tables we should be able to just add a rollup field like so:

---
If the data's keyed in row by row, then selecting the item via the linked field seems like an alright workflow?

If the data all already exists, you quickly link all the data together by:
1. In Sheet A, Click the field header with the unique item names  thereby selecting the entire column
2. Hit CTRL / CMD + C
3. In Sheet A, click the field header for the linked field to Sheet B
4. Hit CTRL / CMD + V

This'll automatically link everything up and the rollup in Sheet B will populate the way you want!

Link to base