Formula to use in the summary field for the number of rows within a specific column

hhsinnovation

For example: If the column is about colors, I want a formula to see how many people chose red or how many people chose green in the survey. And I want this formula to put into the summary field so that I can upload into my summary report and into a chart in dashboard.

Jason P

Hi @hhsinnovation

Assuming you have set up the column for Symbols (Red/Green/Orange) you can use =countifs setting up one summary formula for each colour =COUNTIFS(column name:column name, "green")

Would this work for you?

Jason P

Hi @hhsinnovation

Assuming you have set up the column for Symbols (Red/Green/Orange) you can use =countifs setting up one summary formula for each colour =COUNTIFS(column name:column name, "green")

Would this work for you?

hhsinnovation

Thank you Jason