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

Count Specific word in specific range
 

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

Count Specific word in specific range
 

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" wrote in message
...

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