Formula works but is counting blank cells

Diego Casillas Zaragoza

I got my formula to work =COUNTIFS(Offender:Offender, FIND(Offender@row, @cell) > 0)

but now I have no idea how to make it stop counting the empty cells. Can someone help?

Mark Cronk

Hi @Diego Casillas Zaragoza ,

Try:

=COUNTIF(Offender:Offender, AND(Find(offender@row, @cell) >0, NOT(ISBLANK(@cell))

Work?

Mark

Diego Casillas Zaragoza

Mark,

thanks, so much but it did not work. it is still counting the blanks

Andrée Starå

Hi @Diego Casillas Zaragoza

Mark’s formula should work.

Here’s an alternative you can try as well.

=COUNTIFS(Offender:Offender, FIND(Offender@row, @cell) > 0, Offender:Offender, <>"")

Did that work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!