COUNTIF cells contain a specific word anywhere within the text string

I suspect this isn't possible but perhaps there is a genius out there aware of functionality or a work around that I cant figure out.

If column A has a list of words or phrases in it:
Red Cow
Blue dog
A red mouse
Green and Red puppy

Is there a way to count the number of times the word Red appears
i.e. COUNTIF(A1:A4,'Red') = 3

Recognising the challenge that 'Red' could appear anywhere within the text string of column A.

THANK YOU

WOW, amazing, now there's a functionality I was unaware of! AND so simple too.

THANKS GUYS

Hi, back again.
Any idea how you would use this within a SUMPRODUCT formula.

I have =SUMPRODUCT((G3:G3000="<>*Exclude*")*(B3:B3000=U18)*(D3:D$3000))
But that doesn't seem to work.
Do I need to do something different with it?

Thanks again

=SUMPRODUCT((G3:G3000="<>*Exclude*")*(B3:B3000=U18)*(D3:D$3000))

with corrected syntax would look like this:

=SUMPRODUCT(ISERROR(SEARCH("Exclude",G3:G3000))*(B3:B3000=U18)*(D3:D3000))

Note that this is a summation formula. If you were to get rid of the *(D3:D3000), then it would be a counting formula.

This formula will sum the cells in column D where the corresponding cells in column G does not have "Exude" in it and where the corresponding cells in column B = U18.

Humm, I'm struggling to make this work when integrating into a larger more complex formula. I don't get any errors, but it seems to output the same numbers as when I don't include that 'criteria'.
I assume the 'ISERROR(SEARCH part is doing the job of looking for the word 'Exclude' regardless of where it appears in the text of the G cells. i.e. 'Exclude this' and 'This Exclude'.
Any other things I should be looking out for that could be rendering this inactive?
Thanks

ISERROR(SEARCH("Exclude",G3:G3000)) will return an array of TRUE's and FALSE's for every cell in G3:G3000.

It will return TRUE for every cell that does not have the word Exclude in it and FALSE for every cell that does have the word Exclude in it, even if there is more text in the cell.

All that being said, a SUMIFS formula will do the same thing as the formula from post #7 and run faster.

If you create a small representative sample along with the desired results based off of that sample (which you can enter manually), I'm sure that we can get something working for you.

Cracked it. Simple error in the formula rendering it null.
Thanks for the explanation and offer of help

You're welcome. Glad we could help.