software

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 gt; 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

Hi!

gt;Ex 1- count number of times in 2002 that the score was between 70-74
gt;[inclusive?]

=SUMPRODUCT(--(A1:A100=2002),--(B1:B100gt;=70),--(B1:B100lt;=74))

gt;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))

gt;Ex 3- count number of times in 2004 that the score was gt; 80

=SUMPRODUCT(--(A1:A100=2004),--(B1:B100gt;80))

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:B100gt;D1))

Biff

quot;Neumanquot; gt; wrote in message
...
gt; The 2 columns I'm concerned about a
gt; Column 1 has years (2000-2006)
gt; Column 2 has numbers (70-90) which are my golf scores
gt; Does anyone know how I can run summary statistics on the scores based on
gt; the
gt; years of the first column?
gt; Some examples:
gt; Ex 1- count number of times in 2002 that the score was between 70-74
gt; Ex 2- find the maxmium golf score in 2005
gt; Ex 3- count number of times in 2004 that the score was gt; 80
gt; I know how to use the sumif and countif functions and array formulas, but
gt; haven't been able to get this figured out.
gt; Thank you so much for your help!!
gt; David
Thanks Biff- that's great! I really appreciate it.

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; gt;Ex 1- count number of times in 2002 that the score was between 70-74
gt; gt;[inclusive?]
gt;
gt; =SUMPRODUCT(--(A1:A100=2002),--(B1:B100gt;=70),--(B1:B100lt;=74))
gt;
gt; gt;Ex 2- find the maxmium golf score in 2005
gt;
gt; Entered as an array using the key comination of CTRL,SHIFT,ENTER:
gt;
gt; =MAX(IF(A1:A100=2005,B1:B100))
gt;
gt; gt;Ex 3- count number of times in 2004 that the score was gt; 80
gt;
gt; =SUMPRODUCT(--(A1:A100=2004),--(B1:B100gt;80))
gt;
gt; It's better to use cells to hold the criteria and then just refer to those
gt; cells. This gives you much more versatility.
gt;
gt; C1 = 2004
gt; D1 = 80
gt;
gt; =SUMPRODUCT(--(A1:A100=C1),--(B1:B100gt;D1))
gt;
gt; Biff
gt;
gt; quot;Neumanquot; gt; wrote in message
gt; ...
gt; gt; The 2 columns I'm concerned about a
gt; gt; Column 1 has years (2000-2006)
gt; gt; Column 2 has numbers (70-90) which are my golf scores
gt; gt; Does anyone know how I can run summary statistics on the scores based on
gt; gt; the
gt; gt; years of the first column?
gt; gt; Some examples:
gt; gt; Ex 1- count number of times in 2002 that the score was between 70-74
gt; gt; Ex 2- find the maxmium golf score in 2005
gt; gt; Ex 3- count number of times in 2004 that the score was gt; 80
gt; gt; I know how to use the sumif and countif functions and array formulas, but
gt; gt; haven't been able to get this figured out.
gt; gt; Thank you so much for your help!!
gt; gt; David
gt;
gt;
gt;

You're welcome. Thanks for the feedback!

Biff

quot;Neumanquot; gt; wrote in message
...
gt; Thanks Biff- that's great! I really appreciate it.
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; gt;Ex 1- count number of times in 2002 that the score was between 70-74
gt;gt; gt;[inclusive?]
gt;gt;
gt;gt; =SUMPRODUCT(--(A1:A100=2002),--(B1:B100gt;=70),--(B1:B100lt;=74))
gt;gt;
gt;gt; gt;Ex 2- find the maxmium golf score in 2005
gt;gt;
gt;gt; Entered as an array using the key comination of CTRL,SHIFT,ENTER:
gt;gt;
gt;gt; =MAX(IF(A1:A100=2005,B1:B100))
gt;gt;
gt;gt; gt;Ex 3- count number of times in 2004 that the score was gt; 80
gt;gt;
gt;gt; =SUMPRODUCT(--(A1:A100=2004),--(B1:B100gt;80))
gt;gt;
gt;gt; It's better to use cells to hold the criteria and then just refer to
gt;gt; those
gt;gt; cells. This gives you much more versatility.
gt;gt;
gt;gt; C1 = 2004
gt;gt; D1 = 80
gt;gt;
gt;gt; =SUMPRODUCT(--(A1:A100=C1),--(B1:B100gt;D1))
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Neumanquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; The 2 columns I'm concerned about a
gt;gt; gt; Column 1 has years (2000-2006)
gt;gt; gt; Column 2 has numbers (70-90) which are my golf scores
gt;gt; gt; Does anyone know how I can run summary statistics on the scores based
gt;gt; gt; on
gt;gt; gt; the
gt;gt; gt; years of the first column?
gt;gt; gt; Some examples:
gt;gt; gt; Ex 1- count number of times in 2002 that the score was between 70-74
gt;gt; gt; Ex 2- find the maxmium golf score in 2005
gt;gt; gt; Ex 3- count number of times in 2004 that the score was gt; 80
gt;gt; gt; I know how to use the sumif and countif functions and array formulas,
gt;gt; gt; but
gt;gt; gt; haven't been able to get this figured out.
gt;gt; gt; Thank you so much for your help!!
gt;gt; gt; David
gt;gt;
gt;gt;
gt;gt;