| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting the number of times a word appears | Excel Worksheet Functions | |||
| How do I count the number of times a value appears? | Excel Worksheet Functions | |||
| count the number of times a specific word appears in a column | Excel Worksheet Functions | |||
| How to count the number of times a string appears in a column? | Excel Worksheet Functions | |||
| Count Number of Times Something appears | Excel Worksheet Functions | |||
Threaded Mode
