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"))
Help Article Resources
Check out the Formula Handbook template!