Can Excel do this...

[zsdersw]

I have a column of data in Excel, all of it text, that I want to run a couple specific functions on.

Each cell contains one or more of the following words: Desktop, Laptop, Tab, iPod, Ereader.

Is there a formula I can use that will count the number of times one or more of these words appear in the same column?

In other words, can I count how many times the word "Desktop" appears in this column, even though some of the cells have more than just "Desktop" in them.

Thanks

 

[zsdersw]

Nevermind... the Find function will do that.

 

[kranky]

nvm then.

 

[zsdersw]

Though it would be nice to have this in a formula that dynamically updates as more data is added to the column.

 

[Gooberlx2]

=countif(A:A, "desktop")+countif(A:A, "ipad")+countif(A:A, "laptop")+etc...

 

[JimKiler]

=countif(A:A, "desktop")+countif(A:A, "ipad")+countif(A:A, "laptop")+etc...

you beat me to it!

There is a lot excel can do and I always assume it can do something I want but I have to learn how and what formula(s) to use.