View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SEMonroe SEMonroe is offline
external usenet poster
 
Posts: 1
Default Sum the amount of times a number appears in a column in Excel?

I am using Excel 2003. I have a spreadsheet of Soccer orders. One column
has player numbers entered. I would like to sum the number of times each
number appears in order to know how many numbers I have to order to put on
the jerseys. For instance, if I have three players, numbers 3, 12, 13. I
would have a total of : two number 1's, one number 2, and two number 3's.