Count checkbox and text in a column
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 !
Comments

Try this  just change the column name for yours:

Thanks ! I will try it now

Not working...

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.

My formula was working before they decided to add the n/a....
I've tried your formula in both colums

Yes i've added a column for the formula
Ok l'll try it again.
Thank you so much !
D

Perfect!

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
Categories
Check out the Formula Handbook template!