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
• 28,900 points
117 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
• 53,520 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,630 points
299 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,630 points
106 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
• 53,520 points
140 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
• 53,520 points
111 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
• 53,520 points
223 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
• 22,960 points
373 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
• 53,520 points
99 views
0 votes
1 answer

Multiplying cells and sum then for a range

Use SUM() as an Array formula:  =SUM(IFERROR((AB22:AB1100 = ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 53,520 points
158 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
• 53,520 points
127 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
• 53,520 points
179 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