Assume your sum is in a10 on w/sheet "sheet1"

=COUNTIF(A1:A9,"people")

In your other w/sheet in a10 or wherever input

=sheet1!a10

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"ernie" wrote:

Hey guys pls help me now.

I got a worksheet of raw data. Inside this worksheet, I need to find and
count the number of cells containing the word " People" and this figure will
automatically appear in another worksheet in a cell. Is this possible.

Please advice
--
help me