Help

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

Topic Labels: Data Formulas
225 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Anxious
6 - Interface Innovator
6 - Interface Innovator

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

6 Replies 6

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

Anxious
6 - Interface Innovator
6 - Interface Innovator

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.  😲

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
6 - Interface Innovator
6 - Interface Innovator

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

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

Anxious
6 - Interface Innovator
6 - Interface Innovator

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