Formula for counting registration types
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?
Best Answer
-
The "Summarize" feature has a count option:
Answers
-
A Report would do this for you...
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com
-
Can you please elaborate? The report will be separate by registration type but doesn't give a count of each type.
-
The "Summarize" feature has a count option:
-
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!