Counting amount of times capital word appears in list of rows

Hi,

Quick question. Below I have 5 cells of text in range A1:A5, is it possible to count the amount of times the capital word appears? Example below:

Very stiff extremely high strength dark greenish grey silty CLAY with...
Dark greenish grey slightly clayey silty fine to medium SAND with...
Very stiff extremely high strength dark greenish grey silty CLAY with...
Very stiff extremely high strength dark greenish grey silty CLAY with...
Dark greenish grey slightly clayey silty fine to medium SAND with...

The answer would be

SAND:2
CLAY:3

Thanks for any help

Based on the picture from post #3, try this:

D1 =SUMPRODUCT(--(ISNUMBER(FIND(C1,A$1:A$5))))

Drag down to D2.

Thank you for the replies! It worked!

Much more simpler than the answer I came up with scouring the internet

=SUMPRODUCT((LEN($a$1:$a$1000)-LEN(SUBSTITUTE($a$1:$a$1000,d1,"")))/LEN(d1))

if D1 was the capital word I was looking for