Count Specific word in specific range

Hi

Im having a few problems with a some excel formula's


1:
I need a formula which will calculate a specific word in excel
(specific word=Industrial)
I have already created a formula
=COUNTIF(H10:E12,"*industrial*")
It works fine in one specific range (E.g H10:E12). I need to add
another range in that formula. Everytime i try, i get an error message.
E.G H10: E12 AND F14:G20

2:
In the same spreadsheet i have filled in some cells with different
colours, using the fill tool
Red
Blue
Green

I need a forumla which will calculate each Red cell in a given range?
I need a forumla which will calculate each Blue cell in a given range?
I need a forumla which will calculate each Green cell in a given range?

Again the range i need will be two different ranges. E.g A1:B5 and
D1:D5

I look forward to your response

This has already been answered under your miscellaneous post. It is bad practice to post in more than one bit of the forum (I also see that it is posted under general). People get frustrated reading it 3 times, you do not have all the responses in the same thread, time is wasted if someone has already answered the question elsewhere.

Regards

Dav

Seconded. It has been really tiresome seeing your posts all over the place.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Dav" <Dav.27w7um_1147770604.8658@excelforum-nospam.com> wrote in message
news:Dav.27w7um_1147770604.8658@excelforum-nospam.com...
>
> This has already been answered under your miscellaneous post. It is bad
> practice to post in more than one bit of the forum (I also see that it
> is posted under general). People get frustrated reading it 3 times, you
> do not have all the responses in the same thread, time is wasted if
> someone has already answered the question elsewhere.
>
> Regards
>
> Dav
>
>
> --
> Dav
> ------------------------------------------------------------------------
> Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
> View this thread: http://www.excelforum.com/showthread...hreadid=542402
>