Display text in a countif formula

Carla H

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"))

Paul Newcome

To add text, you would wrap it in quotes and the "add" the formula.

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

Paul Newcome

To add text, you would wrap it in quotes and the "add" the formula.

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

Carla H

thanks @Paul Newcome !! I was using a comma instead of +

You're a lifesaver ⭐️

Paul Newcome

Happy to help! 👍️