Carriage Return within a Cell - COUNTIF

sml385

I have read in other discussions that you can put in a carriage return to JOIN or COUNT through a work around by adding another column. I have tried this with a COUNTIF and I can't get it to work.

My original formula had a comma between the results: ="Exceptional Performance = " + COUNTIF(Accessibility2:Accessibility6, "Exceptional Performance") + ", Good Performance = " + COUNTIF(Accessibility2:Accessibility6, "Good Performance") + ", Mediocre Performance = " + COUNTIF(Accessibility2:Accessibility6, "Mediocre Performance") + ", Poor Performance = " + COUNTIF(Accessibility2:Accessibility6, "Poor Performance")

My updated formula after I added a column titled RETURN: =".Exceptional Performance = " + COUNTIF(Accessibility2:Accessibility6, “Exceptional Performance”) + Return2 + "Good Performance = " + COUNTIF(Accessibility2:Accessibility6, “Good Performance”) + Return2 + "Mediocre Performance = " + COUNTIF(Accessibility2:Accessibility6, “Mediocre Performance) + Return2 + "Poor Performance = " + COUNTIF(Accessibility2:Accessibility6, “Poor Performance”)

Am I doing something wrong or will it not work with a COUNTIF?

Thanks - Sharon

Andrée Starå

Hi @sml385

I hope you're well and safe!

You'd use CHAR(10) for the carriage return.

Something like.

+ CHAR(10) +

Make sense?

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!