| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summary statistics for a golf scores spreadsheet
Hi!
Ex 1- count number of times in 2002 that the score was between 70-74 [inclusive?] =SUMPRODUCT(--(A1:A100=2002),--(B1:B100=70),--(B1:B100<=74)) Ex 2- find the maxmium golf score in 2005 Entered as an array using the key comination of CTRL,SHIFT,ENTER: =MAX(IF(A1:A100=2005,B1:B100)) Ex 3- count number of times in 2004 that the score was 80 =SUMPRODUCT(--(A1:A100=2004),--(B1:B10080)) It's better to use cells to hold the criteria and then just refer to those cells. This gives you much more versatility. C1 = 2004 D1 = 80 =SUMPRODUCT(--(A1:A100=C1),--(B1:B100D1)) Biff "Neuman" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summary statistics for a golf scores spreadsheet
Thanks Biff- that's great! I really appreciate it.
"Biff" wrote: Hi! Ex 1- count number of times in 2002 that the score was between 70-74 [inclusive?] =SUMPRODUCT(--(A1:A100=2002),--(B1:B100=70),--(B1:B100<=74)) Ex 2- find the maxmium golf score in 2005 Entered as an array using the key comination of CTRL,SHIFT,ENTER: =MAX(IF(A1:A100=2005,B1:B100)) Ex 3- count number of times in 2004 that the score was 80 =SUMPRODUCT(--(A1:A100=2004),--(B1:B10080)) It's better to use cells to hold the criteria and then just refer to those cells. This gives you much more versatility. C1 = 2004 D1 = 80 =SUMPRODUCT(--(A1:A100=C1),--(B1:B100D1)) Biff "Neuman" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summary statistics for a golf scores spreadsheet
You're welcome. Thanks for the feedback!
Biff "Neuman" wrote in message ... Thanks Biff- that's great! I really appreciate it. "Biff" wrote: Hi! Ex 1- count number of times in 2002 that the score was between 70-74 [inclusive?] =SUMPRODUCT(--(A1:A100=2002),--(B1:B100=70),--(B1:B100<=74)) Ex 2- find the maxmium golf score in 2005 Entered as an array using the key comination of CTRL,SHIFT,ENTER: =MAX(IF(A1:A100=2005,B1:B100)) Ex 3- count number of times in 2004 that the score was 80 =SUMPRODUCT(--(A1:A100=2004),--(B1:B10080)) It's better to use cells to hold the criteria and then just refer to those cells. This gives you much more versatility. C1 = 2004 D1 = 80 =SUMPRODUCT(--(A1:A100=C1),--(B1:B100D1)) Biff "Neuman" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
