COUNTIF

[ExcelRoy]

Hi all,

Could I please ask for some help

I am trying to count the contents of column M25:M124 if there is blanks in column N25:N124

I was playing with the following formula

=IF(B9="","","Unconfirmed > " & COUNTIF(N25:N124,""))

I need the count to work if there is a date in M and nothing in N

Many thanks

 

[ExcelRoy]

lots of investigation need then, many thanks Joe4

 

[ExcelRoy]

Hi Joe4,

The formula links to another formula
=IF(C6&I6="","",IFERROR(LOOKUP(2,1/($HL$3:$HL$502=C6)/($HE$3:$HE$502=I6),($HN$3:$HN$502)),""))

Not sure if this makes any difference

Thanks

 

[Joe4]

I am not sure how much of that matters. Do you understand what all of these formulas are doing are what they are ultimately returning to cell N27?
You need to ascertain what is actually being returned to cell N27.

This should tell you that:
=CODE(N27)

This will return the ASCII character representation of the character being returned in cell N27 (i.e. if it returns "32", it is a single space).
So, once you determine what is being returned in cell N27, you need to evaluate if that is, indeed, correct, if that is what you actually want your formula to return to that cell, or if your underlying formulas need more tweaking. Without knowing all the background information and what it is all supposed to be doing, I cannot tell you that.

 

[ExcelRoy]

Hi Joe4,

Many thanks, using this method of fault finding I was able to identify the error was in actual fact a " " in the first set of data that generates the formula's

Great tool to use for the future, many thanks

 

[Joe4]

You are welcome.