Display text in a countif formula

I have a project type column and I want to show in the summary row at the top of my sheet the number of PoCs and Pilots.

Instead of just displaying the number, I want the cell to read PoCs = 22 or Pilots = 15

=(COUNTIF([Project Type]3:[Project Type]69, ="PoC"))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!