Countif: Not counting FALSE results.

countryfan_nt

Well-known Member
Joined
May 19, 2004
Messages
685
Hello friends, hope all is well!

Really appreciate your support please

I have a range K9:K150

I placed the following formula:
=IF(AND(COUNTA(A10:E10)>0,C10=""),"FALSE",IF(C10="","",IF(ISERROR(VLOOKUP(C10,Database!$A$2:$A$24,1,FALSE)=FALSE),FALSE,TRUE)))

Now I wish to count the number of FALSE.

I keep getting 0. Please help me edit the formula:
=COUNTIF(M9:M1500,FALSE)

Thank you very much in advance
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,261
Office Version
365
Platform
Windows
Remove the quotes from around the word FALSE in the col M formula
 

Watch MrExcel Video

Forum statistics

Threads
1,100,140
Messages
5,472,751
Members
406,835
Latest member
steve43040

This Week's Hot Topics

Top