View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tech1NJ tech1NJ is offline
external usenet poster
 
Posts: 58
Default counting totals based on certain criteria - Excel 2K

I am working with a book and 2 sheets. Sheet 1 has data on 3 columns and 100s
of rows. Sheet 2 has specific names in ColumnA3 to A18 that may show up on
Sheet 1 column C. What I like to do is count the number of times the name
appears in Sheet 1 Column C. The number should be logged into Sheet 2 B3 to
B18. Is there a way to do this.

PLEASE HELP!!!!!!!!!!!!!!!--
tech1NJ