Count Index Match Formula

Rosetta Gordon
βββ
I want a formula to retrieve a count of how many nurses have a BSN degree by unit from a spreadsheet. I have a sheet with the list of units as the primary column and degrees listed for the other columns. The formula needs to look at the main data sheet for this number. Is this possible?
Answers
-
You would need a COUNTIFS function.
=COUNTIFS({Source Sheet Unit Column}, @cell = "Unit A", {Source Sheet Degree Column}, @cell = "BSN")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!