Count Specific word in Specific range

S

sizz1

Hi i need a little help with some excel formulas

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Count If Specific word in specific range 2
Count Specific word in specific range 2
Count specific word in a specific range 2
Remove Identical words 0
Count Filled colour in cell in given range 4
How to modify and updte specific styles for specific paragraphs across the document 0
Count in a range of numbers 9

Top