Formula

jgneely72151 · 10/12/21

Hello,

How do I enter the formula that counts the slots following the text "Total slots filled =" ?

I want the calculation in the same cell with the text and not in a separate cell, plus I want it to count blanks.

Andrée Starå · 10/13/21

Hi @jgneely72151

I hope you're well and safe!

Try something like this.

="Total Slots Filled = " + COUNTIF(CHILDREN(), <>"")

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!

jgneely72151 · 10/13/21

It most definitely did. Thank you so much!

Andrée Starå · 10/13/21

@jgneely72151

Excellent!

You're more than welcome!

✅Remember! 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!

Andrée Starå · 10/13/21