check out this reference:

http://www.pcreview.co.uk/forums/thread-1770361.php

you can generalize this by using your range in place of ROWS(1)
--
Gary''s Student


"Robert Shlemkevich" wrote:

I am looking for a way to do one of two things. Either count the number of
comments in a row or column of cells, or to count the number of times a
specific word appears in a series of comments in a row or column.

Any suggestions?