countryfan_nt
Well-known Member
- Joined
- May 19, 2004
- Messages
- 765
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
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