Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

How do I sum options for each

Topic Labels: Base design
620 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hey there Airtable community, newbie here. Literally day 1!

I am trying to figure out how to calculate the sum of how many times each option (Easy to use, I lose weight, etc) of both columns (Product benefits, Product features) appears.

So basically I want to see the following:

Product benefits:

Gives me energy: 4
Easy to use: 2
I lose weight: 2
I don’t have anxiety anymore: 2

Product Features:

I like the colour: 2
It’s tasty: 2
It comes from South America 1

Can anybody help?

Screenshot 2022-06-18 at 22.12.36

1 Reply 1

Hi Lorenzo, if I were you I’d just convert the two multiple select fields into linked fields, and use a count field on the new table

Which should give you something like this:
Screenshot 2022-06-19 at 2.10.59 PM

If the survey is ongoing, we could make an automation that would paste the values from the multiple select field into the linked field so that you don’t have to do stuff manually.

If you only need a visual representation, then a chart or pivot app might do just fine for you too
Screenshot 2022-06-19 at 2.16.30 PM