I have a spread sheet with a colomn with the following formula copied down

```=IF(L3 = "N/A","No Action",(IF((J3<>""),(IF((K3<>""),(IF((K3>J3),"FALSE","TRUE")),"N/A")),"")))
```

which gives me the results below in column "M"

TRUE
TRUE FALSE
No Action
N/A
N/A
No Action
N/A
N/A
No Action
No Action
No Action

So I used the following formula in another sheet

=COUNTIF(Sheet1!M:M,"N/A") which gives "4"
=COUNTIF(Sheet1!M:M,"No Action") gives "5"

How ever =COUNTIF(Sheet1!M:M,"FALSE") or =COUNTIF(Sheet1!M:M,"TRUE")

Give the result "0"

I think this is due to "TRUE and FALSE" being keywords in excel but is there a way I can get excel to count the cells with these values without renaming them?

Sep 26, 2022 in Others 342 views

## 1 answer to this question.

Please see MS Excel: COUNTIF Function (WS)

You should change the criteria to "=TRUE" like this:

`=COUNTIF(A1:A11;"=TRUE")`
• 63,160 points

## MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

## Moving Average formula in Excel not autofilling in table

You could use AVERAGEIFS to make the ...READ MORE

## Excel COUNTIF "Column D" year equals 2015 and Column L equals "15 or greater"

COUNTIFS() with an S allows the ability of multiple ...READ MORE

## Excel Formula Query on Summing Annual Leave Days and Half Days

Try Something like =SUM(COUNTIF(\$A\$1:\$A\$8,"A"),COUNTIF(\$A\$1:\$A\$8,"HA")/2) - total count ...READ MORE

## How to use COUNTIFS with multiple conditions and columns in Excel?

Use  SUMPRODUCT and double unay operators: =SUMPRODUCT ...READ MORE

## Want to compare two columns in excel

Hello To compare two columns in excel ...READ MORE

## Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE