Count Index Match Formula
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!