Countif not returning the value I need.

[JJenkx]

Please forgive the noobness here. I didnt know how to sum 2 cells together at the start and managed this monstrosity after one month of free time. Cell n408 is returning the date I want and cell p408 is not. Once I understand why I can fix the rest. Thanks for any insight.


https://1drv.ms/u/s!AnGyPf0O5lMAgQHrvAYZef2NTre6?e=HjBzWS

 

[Special-K99]

Ignore this post, i was reading the wrong cell...thinking...

 

[JJenkx]

When I trace precedents, it show S84 for me which includes ISHF and still returns blank

 

[JJenkx]

Ignore this post, i was reading the wrong cell...thinking...

Thank you for your time

 

[Fluff]

The values in B74 & B75 both have a space after the word "Inspect", so the countif returns 0 (ie false).
Remove the space & it should work

 

[Special-K99]

OK, got it.

The AND comprises an ISBLANK, ISNUMBER, and a COUNTIF
The COUNTIF for P408 is searching for B71:B130 for J117

J117 is Inspect

There is no Inspect in the range B71:B130 therefore the AND() will fail and a blank will be returned.

For N408

J116 is Full
Full occurs in B71:B130 so you get a result for N408.

 

[JJenkx]

You are awesome!! Thank you. What is a good countif replacement that will return true if there is a space?

 

[Fluff]

Me thinks that Special-K99 & I are looking at different sheets.
Not sure which sheet you were referring to, but I was talking about "MN SN 2" and I think Special-K99 is referring to "MN SN 1"

 

[Fluff]

You are awesome!! Thank you. What is a good countif replacement that will return true if there is a space?

The best way, would be to remove the space. Otherwise it could cause further problems in future.

 

[JJenkx]

Me thinks that Special-K99 & I are looking at different sheets.
Not sure which sheet you were referring to, but I was talking about "MN SN 2" and I think Special-K99 is referring to "MN SN 1"

I totally forgot I had more than one sheet on that file. I was having trouble with "MN SN 2" sheet and the space after "Inspect" was what broke it