Totaling a dollar amount if a dropdown menu matches a criteria.

[Anxious]

I think what I am wanting to do is also possible with a rollup field. However, I can't get it to work.

I have a column that I want to add all the values on a different table.

Table 1 has all the prices in it.

Item 1 > Shoe > $39.95
Item 2 > Shoe > $39.95
Item 3 > Shirt > $19.95

I want to add all the "Shoes" together in Table 2 and display that total.

So I made a rollup field and said if the values in table 1 match "shoes" then "insert formula here"

I tried using SUM....but I am not doing something right. Am I overthinking this? XD

[TheTimeSavingCo]

Could you provide screenshots of the relevant tables and the setup of the formula field please?

[Anxious]

I made an example base:

https://airtable.com/shrwA5tpgORZyaULy

What I am trying to do is best suited for Google Sheets really, but all my data is in Airtable.  😲

[TheTimeSavingCo]

Thanks for the example base!  You'll need to link all your records in Table 1 to a single record in Totals, once you've done that it should work as expected

[Anxious]

I just gives me all zeros instead of the actual total. 😕 Not sure what I am doing wrong.

[TheTimeSavingCo]

Could you make your changes to the example base so that I can help troubleshoot?

[Anxious]

I gave up and just made a "grouped" view.