Count checkbox and text in a column

TechDo · 01/30/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 !

Nic Larsen · 01/30/19

Try this - just change the column name for yours:

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

TechDo · 01/30/19

Thanks ! I will try it now

TechDo · 01/30/19

Not working...

Nic Larsen · 01/30/19

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.

TechDo · 01/30/19

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

I've tried your formula in both colums

Nic Larsen · 01/30/19

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.

Nic Larsen · 01/30/19

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"))

TechDo · 01/30/19

Yes i've added a column for the formula

Ok l'll try it again.

Thank you so much !

D

TechDo · 01/30/19

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

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

Thank you again !

Nic Larsen · 01/30/19

Perfect!

JennS_ · 05/21/19

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.

formula row.JPG

Formulas and Functions

Formulas and Functions

Count checkbox and text in a column

Comments

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Counting occurrences of a string in a row

Rounding to nearest Thursday in the past or current day if it's Thursday

JOIN function in a Sheet Summary