Hi

Supposing the text you want to look at is all contained in column A and
the value being searched "rain" is held in D1
In cell C10
=SUMPRODUCT((ISNUMBER(FIND($D$1,$A1:$A1000)))*
(ISNUMBER(FIND(B$10,$A$1:$A$1000)))*
(ISNUMBER(FIND($C10,$A$1:$A$1000))))

--
Regards

Roger Govier


"Zimina" wrote in message
...
Hi,
I'm stumped on this one but I'm sure that it's doable.
I have a table of data based on Towns and Dates.

Let's say there are
10 Towns from B10 to B19 and
Dates are from C9 to I9

The table data is text extracts from diary entries for each Date in
each Town. The data may (or may not) include remarks about the
weather. (Isn't this interesting!).
Basically, I want to be able to count instances of the word "rain" in
the data entries and display the sum of occurrences horizontally (by
Town) in column A and vertically (by Date) in row 7.

Thanks in advance for any advice.

Zimina