Conditional rollup



I have an AirTable with two Tables. I am a hobbyist trying to track a video game I play :slight_smile:

First is a table that has:

  • Trader Name
  • Total Gold

Second is a table that has:

  • Trade Number (auto number)
  • Trader Name (this links to “Trader Name”)
  • Item
  • Gold Spent

For the “Total Gold” value, I want to add all the “Gold Spent” up that matches the trader, so I can see how much gold I spend on each player in my video game.

Can someone help me build a conditional statement for this. Also, if it’s not too much, how can I build things like this in the future? :smiley: