Count Index Match Formula

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!