Sign in to join the conversation:
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 !
Try this - just change the column name for yours:
=COUNTIF(CheckBox:CheckBox, OR(@cell = 1, @cell = "N/A"))
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
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.
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"))
Yes i've added a column for the formula
Ok l'll try it again.
Thank you so much !
D
It worked !!!!! I just had a space to remove !!!!
=COUNTIF([Doc 1B ]:[Doc 1B ]; OR(@cell = 1; @cell = "n/a"))
Thank you again !
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.
I currently have 14 sheets with the following columns: Batch # and Reviewer I use an Index Distinct formula to acquire the unique batch numbers from all 14 sheets and put them into 14 columns on the 'metrics' sheet. I then use another index distinct to get a list of all the unique batch numbers into one 'Unique Batch…
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
When I use a formula to return a symbol for example =IF([INC/DEC]@row = "INCREASE", "RED", "GREEN") It just returns the word RED I have the column set to symbol but still can't get it to work…
