Formula for counting registration types

Courtney Davis

Hello, I have a registration sheet and I'm trying to calculate the total number of in-person registrants we have and other registration types. What formula should I use for this?

Neil Watson

The "Summarize" feature has a count option:

Brent Wilson

A Report would do this for you...

Courtney Davis

Can you please elaborate? The report will be separate by registration type but doesn't give a count of each type.

Neil Watson

The "Summarize" feature has a count option:

Matt Johnson

HI @Courtney Davis

Brent's idea is good and you can drill into each type. You would go to the summarize feature in the heading of the report, like Neil showed, and from there you can choose to count the types and then collapse the groups while still showing the counts.

Or, you could add a Sheet Summary field (the little book icon on the right of the sheet screen) and do the formula below. The column1 would be the name of Registration Type column and you would enter the type in quotes that would be counted. If you have a lot of types, you might want to put them in a separate Metric Sheet and do a cross sheet reference formula. You would list all the types in one column, and then the formula once, having the type be the value in the first column. The range though would pull from the original sheet. Then you could drag the formula down and get all the counts. This would also be good if you wanted to display these counts on a chart or graph on a dashboard. Just remember, if you add a new type to the original sheet, you'll need to add it to the metric sheet as well.

=COUNTIF([column1]:[column1], "type")

I hope that helps!