| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summary statistics for a golf scores spreadsheet
The 2 columns I'm concerned about a
Column 1 has years (2000-2006) Column 2 has numbers (70-90) which are my golf scores Does anyone know how I can run summary statistics on the scores based on the years of the first column? Some examples: Ex 1- count number of times in 2002 that the score was between 70-74 Ex 2- find the maxmium golf score in 2005 Ex 3- count number of times in 2004 that the score was 80 I know how to use the sumif and countif functions and array formulas, but haven't been able to get this figured out. Thank you so much for your help!! David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| baseball Statistics spreadsheet | Excel Discussion (Misc queries) | |||
| Golf scores table | Excel Discussion (Misc queries) | |||
| Golf Handicap Using Last 5 Scores | Excel Worksheet Functions | |||
| how to combine several tabs on a spreadsheet into a summary tab w. | Excel Discussion (Misc queries) | |||
| Creating a summary from existing spreadsheet data ... | Excel Worksheet Functions | |||
Threaded Mode
