Excel COUNTIF formula

0 votes

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 by Kithuzzz
• 38,020 points
739 views

1 answer to this question.

0 votes

Please see MS Excel: COUNTIF Function (WS)

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

=COUNTIF(A1:A11;"=TRUE")
answered Sep 29, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
982 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

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

Feb 18, 2022 in Others by Edureka
• 13,690 points
382 views
0 votes
1 answer

Moving Average formula in Excel not autofilling in table

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

answered Oct 2, 2022 in Others by narikkadan
• 63,720 points
1,180 views
0 votes
1 answer

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

answered Oct 3, 2022 in Others by narikkadan
• 63,720 points
890 views
0 votes
1 answer

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

answered Oct 3, 2022 in Others by narikkadan
• 63,720 points
1,854 views
0 votes
1 answer

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

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

answered Apr 4, 2023 in Others by Kithuzzz
• 38,020 points
551 views
0 votes
1 answer

Want to compare two columns in excel

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

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
1,061 views
0 votes
1 answer

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

answered Sep 30, 2022 in Others by narikkadan
• 63,720 points
716 views
0 votes
1 answer

Excel - IF Formula with a FIND

What about using mid() to see if ...READ MORE

answered Sep 27, 2022 in Others by narikkadan
• 63,720 points
685 views
0 votes
1 answer

Excel formula to check date within this week and last week

Assuming the first date in A2 try this formula ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
• 63,720 points
1,821 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP