COUNTIF not blank

laura.buchanan · 11/06/20

I simply want to count all of the cells in a column that aren't blank

=COUNTIF(COLUMNA:COLUMNA), "isnotblank")

This doesn't work

Any ideas?

Andrée Starå · 11/06/20

Hi @laura.buchanan

Try something like this.

=COUNTIF(COLUMNA:COLUMNA), <>"")

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

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!

Laura Bell · 02/11/21

@Andrée Starå I am trying to use this formula to pull information from a reference sheet. However, when I add a second countif formula it changes the first one. Can I have two countif on the same sheet?

When I change the formula for total RFI it changes my formula to match in the total completed and vice versa.

Thank you!

Andrée Starå · 11/06/20

Hi @laura.buchanan

Try something like this.

=COUNTIF(COLUMNA:COLUMNA), <>"")

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

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!

laura.buchanan · 11/06/20

That worked perfectly!! Thank you!

L

Andrée Starå · 11/06/20

@laura.buchanan

Excellent!

You're more than welcome!

David Joyeuse · 11/06/20

@laura.buchanan

Well, the COUNT function is already couting cells that aren't empty, so...

=COUNT([COLUMNA]:[COLUMNA]) is more than enough :P

Can't believe Andre missed that :D

Andrée Starå · 11/06/20

@David Joyeuse

Haha!

Thanks, but to my defense, I was low on coffee, and I didn't know if Laura wanted to build upon the formula further.

Laura Bell · 02/11/21

@Andrée Starå I am trying to use this formula to pull information from a reference sheet. However, when I add a second countif formula it changes the first one. Can I have two countif on the same sheet?

When I change the formula for total RFI it changes my formula to match in the total completed and vice versa.

Thank you!

mmoulton · 02/02/23

Hello,

I'm working with two sheets and want to count the non-bank cells that meet a condition. I'm hitting a wall!

Sheet 1 with the data:

Sheet 2 is where formula goes

What I need: if the Status is Active, how many non-blank cells are there in the "Direction" column?

I've tried so many countifs combinations and nothing works. HALP, please!

-MMoulton

Rachelle · 03/01/24

https://community.smartsheet.com/discussion/comment/360161#Comment_360161

where about to get help with this formula? i am looking for something very similar and cannot figure it out.

COUNTIF not blank

Best Answers

Answers

Help Article Resources

Categories