# Count checkbox and text in a column

Options
edited 12/09/19

Hi, is it possible to count in a column, if I have check box and also N/A ?

I need to count every cell that has a check in the box or the N/A.

Thank you !

Tags:

• ✭✭✭✭✭✭
Options

Try this - just change the column name for yours:

=COUNTIF(CheckBox:CheckBox, OR(@cell = 1, @cell = "N/A"))

• Options

Thanks !  I will try it now

• Options

Not working...

• ✭✭✭✭✭✭
Options

Hmm. Can you share a screen shot of the column with the column name? It worked when I tested it. Sometimes copying/pasting a formula from here fails, better to type it out.

• Options

My formula was working before they decided to add the n/a....

I've tried your formula in both colums

• ✭✭✭✭✭✭
Options

Make sure you bracket your column name in the formula if you have spaces in there. It appears you do. I've adjusted mine.

=COUNTIF([Check Box]:[Check Box], OR(@cell = 1, @cell = "N/A"))

Otherwise, I am happy to look at a copy of the sheet if you want to share it.

• ✭✭✭✭✭✭
Options

Also - Are you doing the formula in the Top/2nd row rather than an adjacent column. That may be the issue with my formula since its looking at the entire column. Adjust the Range if that's the case.

Example

=COUNTIF([Check Box]2:[Check Box]100, OR(@cell = 1, @cell = "N/A"))

• Options

Yes i've added a column for the formula

Ok l'll try it again.

Thank you so much !

D

• Options

It worked !!!!! I just had a space to remove !!!!

=COUNTIF([Doc 1B ]:[Doc 1B ]; OR(@cell = 1; @cell = "n/a"))

Thank you again !

• ✭✭✭✭✭✭
Options

Perfect!

• ✭✭✭
edited 05/22/19
Options

I have a similar request, but I want to count any text in a row, not a specific word or phrase. For example, each row may have a different "comment" in a cell. Is there a way to make a formula that counts the checkbox, if checked, and also count if there is text in a cell.

Current formula is set up to count anything in that row, that is labeled "C" (for critical) when the checkbox is checked.

=IF(Critical@row = "C", COUNTIFS(Carleen75:Janet75, 1))

But when we have text in that row, it doesn't count it.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!