Count Specific word in specific range

[sizz1]

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
D15

I look forward to your response

 

[Dav]

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

Regards

Da

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)