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

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

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

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