=countif(a2:a400,"orange")
or
=countif(sheet2!a2:a400,"orange")



jh3016 wrote:

Another question....

How do I count this?

If Sheet2 A2:A400 = "Orange", count how many times "Orange" appears.

"jh3016" wrote:

I have an excel workbook with two sheets.

On Sheet2, in column A is employee name. In column B is comments about that
employee. The employee's name could be repeated several times throughout the
workbook. Sheet2 has 1000 rows with multiple employees on it.

On Sheet1 I want to put all the comments that match Employee1 (which is in
cell A1 on Sheet1). There will probably be 20 matches, so I want the
comments to be in rows 2-21.

Is this possible?

Thanks in advance.

--

Dave Peterson