Second search criteria

[Pat1009]

Hello board,
I have this formula....

=COUNTIFS('Assets Open'!$N:$N,">="&W3 -6,'Assets Open'!$N:$N,"<="&W3 +1,'Assets Open'!$K:$K,"john*smith")

It works great. But I want to add another criteria in the same column K:K
So it will search for a blank cell in addition to john smith.... count them both together.

 

[Pat1009]

Re: Need help with a second search criteria

I believe I have figured out what was wrong, instead of a +1 it should have been a +2, thx all.

 

[Aladin Akyurek]

Re: Need help with a second search criteria

I believe I have figured out what was wrong, instead of a +1 it should have been a +2, thx all.

You are welcome.