Counting specific values in a column
Hi, This should be easy...
I am trying to sum up the number of single rooms and the number of double rooms and I can't get it to work.
I just want it to count how many "SGL" and separately how many "DBL"
Any advice?
Thank you.
Mike
Best Answers
-
Hi @Mike P - adjust the ranges in the below formulas, but it should just be:
For Single Rooms
=COUNT([Room Type]1:[Room Type]26, "SGL")
For Double Rooms
=COUNT([Room Type]1:[Room Type]26, "DBL")
-
Thank you Lucas - I needed to change it to COUNTIF, but other than that, it worked! Thank you so much.
Answers
-
Hi @Mike P - adjust the ranges in the below formulas, but it should just be:
For Single Rooms
=COUNT([Room Type]1:[Room Type]26, "SGL")
For Double Rooms
=COUNT([Room Type]1:[Room Type]26, "DBL")
-
Thank you Lucas - I needed to change it to COUNTIF, but other than that, it worked! Thank you so much.
-
Ha! Rushed myself apparently. Glad you got it working.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 297 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!