I want to type a formula that will look at a range of cells and
count
1 each time it finds any of a list of words. So if my range of cells
is
A1:A50 and the word "math" is in cells A2 and A4 and the word
"science" is in cells A5 and A10 it would bring back a count of 4.

All help is greatly appreciated.

Sounds like you may need more but try this for starters
=COUNTIF(A1:A50,"math")+COUNTIF(A1:A50,"science")

HTH
Martin


"japc90" wrote in message
...
I want to type a formula that will look at a range of cells and
count
1 each time it finds any of a list of words. So if my range of cells
is
A1:A50 and the word "math" is in cells A2 and A4 and the word
"science" is in cells A5 and A10 it would bring back a count of 4.

All help is greatly appreciated.

Hi

Say your list of words is in B1:B10 then you could use:

=SUM(COUNTIF(A1:A50,"*"&B1:B10&"*"))

Confirmed with Ctrl+Shift+Enter

Richard





On 7 Jan, 11:40, japc90 wrote:
*I want to type a formula that will look at a range of cells and
count
1 each time it finds any of a list of words. So if my range of cells
is
A1:A50 and the word "math" is in cells A2 and A4 and the word
"science" is in cells A5 and A10 it would bring back a count of 4.

All help is greatly appreciated.