Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Rollup Feature for Counting Single Select Field

Topic Labels: Formulas
1668 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello community, I have an issue where I have a list of people who took part in a survey, for which I have assigned gender to in a single select field.

In the next tab I have a rollup field which to bring up the number of males and then another field for females and so on. However, I cannot seem to get it to count the number of males who took part for example.

  • Is rollup correct for this?
  • I tried typing in COUNTALL(“males”), result is 1
2 Replies 2

Hi @Alex_Lee

You can’t do selective roll ups - but there is a solution…

  1. Create two formula fields in the original table, one called, say, Is Female, and the other called Is Male. Each would have a formula like IF(Gender = “Female”,1,0) (this for the Is Female field)

  2. You can then use roll up fields with a Sum(Values) option to add up the number of males and females into two separate fields.

I hope this helps.

Julian

Thank you, it is solved beautifully now, i love the IF() function now