Sum Product and Blanks

[Legacy 380435]

Hi there,

I have the below formula, but i am wanting it to return "true" if the searched cell is also blank, but i cannot seem to get the formula right.

So if cell D5 contains, Near Miss, Incident or a blank cell= true

=SUMPRODUCT(--ISNUMBER(SEARCH({"Near Miss","Incident"},D5)))>0

Any ideas how i can adapt this cell to include that?

 

[steve the fish]

Using your formula you could add this part:

=SUMPRODUCT(--ISNUMBER(SEARCH({"Near Miss","Incident"},D5))[COLOR=#ff0000]+(D5="")[/COLOR])>0

 

[Legacy 380435]

Using your formula you could add this part:

=SUMPRODUCT(--ISNUMBER(SEARCH({"Near Miss","Incident"},D5))[COLOR=#ff0000]+(D5="")[/COLOR])>0

Amazing, thank you very much!!