Michael168 wrote:
*On Sheet1 the column A range consists of different names.
On sheet2 the cell A1 was use to count / total no times the same
names appear in column A

=COUNTIF(Sheet1!A5:A1815,"=Dave")


Thank you. *



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/