I hope i can make this make sense.
I have a spreadsheet that I've merged multiple sheets into. going down the
sheet there are multiple cells that have the same label, and adjacent to
that label in the next cell is a number. So I might have in C14 the word
tardiness and in B14 will be a score, like "4". now this gets repeated all
the way down, so maybe C42 we'll find tardiness again, and in B42 we'll have
a 2, etc. What I'd like to do is have the average of everything labeled
"tardiness" to be placed in cell H2. Where do I even start? I'll have to do
this with multiple labels and values.

Use the SumIf function, check out Excel help for the details...
=SUMIF(C2:C100,"tardiness",B2:B100)
--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/ExtrasForXL add-in

..
..
..

"Jimbo" <(E-Mail Removed)>
wrote in
message news:i4hmpn$73i$(E-Mail Removed)...
I hope i can make this make sense.
I have a spreadsheet that I've merged multiple sheets into. going down the
sheet there are multiple cells that have the same label, and adjacent to
that label in the next cell is a number. So I might have in C14 the word
tardiness and in B14 will be a score, like "4". now this gets repeated all
the way down, so maybe C42 we'll find tardiness again, and in B42 we'll have
a 2, etc. What I'd like to do is have the average of everything labeled
"tardiness" to be placed in cell H2. Where do I even start? I'll have to do
this with multiple labels and values.

Thank you so much Jim!
this is a great start, do you have any ideas on how to get the average
instead of the sum? I'm not sure if there is an "averageif" function.


"Jim Cone" <(E-Mail Removed)> wrote in message
news:i4hnnl$9e3$(E-Mail Removed)...
>
> Use the SumIf function, check out Excel help for the details...
> =SUMIF(C2:C100,"tardiness",B2:B100)
> --
> Jim Cone
> Portland, Oregon USA
> http://tinyurl.com/ExtrasForXL add-in
>
> .
> .
> .
>
> "Jimbo" <(E-Mail Removed)>
> wrote in
> message news:i4hmpn$73i$(E-Mail Removed)...
> I hope i can make this make sense.
> I have a spreadsheet that I've merged multiple sheets into. going down the
> sheet there are multiple cells that have the same label, and adjacent to
> that label in the next cell is a number. So I might have in C14 the word
> tardiness and in B14 will be a score, like "4". now this gets repeated all
> the way down, so maybe C42 we'll find tardiness again, and in B42 we'll
> have
> a 2, etc. What I'd like to do is have the average of everything labeled
> "tardiness" to be placed in cell H2. Where do I even start? I'll have to
> do
> this with multiple labels and values.
>
>

Type AverageIf into the "help" box in Excel, what you get depends on your Excel version.
If you get nothing then go back to the basics: Average = Sum of the Items/Number of Items...

=SUMIF(C2:C100,"tardiness",B2:B100)/COUNTIF(C2:C100,"tardiness")
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
..
..
..

"Jimbo" <(E-Mail Removed)>
wrote in message news:i4hogi$b5d$(E-Mail Removed)...
Thank you so much Jim!
this is a great start, do you have any ideas on how to get the average
instead of the sum? I'm not sure if there is an "averageif" function.


"Jim Cone" <(E-Mail Removed)> wrote in message
news:i4hnnl$9e3$(E-Mail Removed)...
> Use the SumIf function, check out Excel help for the details...
> =SUMIF(C2:C100,"tardiness",B2:B100)
> --
> Jim Cone
> Portland, Oregon USA
> http://tinyurl.com/ExtrasForXL add-in
>
> .
> .
> .
>
> "Jimbo" <(E-Mail Removed)>
> wrote in
> message news:i4hmpn$73i$(E-Mail Removed)...
> I hope i can make this make sense.
> I have a spreadsheet that I've merged multiple sheets into. going down the
> sheet there are multiple cells that have the same label, and adjacent to
> that label in the next cell is a number. So I might have in C14 the word
> tardiness and in B14 will be a score, like "4". now this gets repeated all
> the way down, so maybe C42 we'll find tardiness again, and in B42 we'll
> have
> a 2, etc. What I'd like to do is have the average of everything labeled
> "tardiness" to be placed in cell H2. Where do I even start? I'll have to
> do
> this with multiple labels and values.

On Aug 18, 6:31*pm, "Jim Cone" <james.cone...@comcast.netXXX> wrote:
> Type AverageIf into the "help" box in Excel, what you get depends on yourExcel version.
> If you get nothing then go back to the basics: *Average = Sum of the Items/Number of Items...
>
> =SUMIF(C2:C100,"tardiness",B2:B100)/COUNTIF(C2:C100,"tardiness")
> --
> Jim Cone
> Portland, Oregon *USAhttp://www.contextures.com/excel-sort-addin.html
> .
> .
> .
>
> "Jimbo" <warblade...@hotmail.com>
> wrote in messagenews:i4hogi$b5d$(E-Mail Removed)...
> Thank you so much Jim!
> this is a great start, do you have any ideas on how to get the average
> instead of the sum? I'm not sure if there is an "averageif" function.
>
> "Jim Cone" <james.cone...@comcast.netXXX> wrote in message
>
> news:i4hnnl$9e3$(E-Mail Removed)...
>
>
>
> > Use the SumIf function, check out Excel help for the details...
> > =SUMIF(C2:C100,"tardiness",B2:B100)
> > --
> > Jim Cone
> > Portland, Oregon *USA
> >http://tinyurl.com/ExtrasForXLadd-in
>
> > .
> > .
> > .
>
> > "Jimbo" <warblade...@hotmail.com>
> > wrote in
> > messagenews:i4hmpn$73i$(E-Mail Removed)...
> > I hope i can make this make sense.
> > I have a spreadsheet that I've merged multiple sheets into. going down the
> > sheet there are multiple cells that have the same label, and adjacent to
> > that label in the next cell is a number. So I might have in C14 the word
> > tardiness and in B14 will be a score, like "4". now this gets repeated all
> > the way down, so maybe C42 we'll find tardiness again, and in B42 we'll
> > have
> > a 2, etc. What I'd like to do is have the average of everything labeled
> > "tardiness" to be placed in cell H2. Where do I even start? I'll have to
> > do
> > this with multiple labels and values.- Hide quoted text -
>
> - Show quoted text -

Change to suit and ARRAY enter (ctrl+shift+enter)
=AVERAGE(IF((A2:A22="a"),B2:B22))

thanks for all your help guys! this works, until i get 2007!

;-)

"Don Guillett Excel MVP" <(E-Mail Removed)> wrote in message
news:5dd6c9c1-bf7c-4eaa-a4e6-(E-Mail Removed)...
On Aug 18, 6:31 pm, "Jim Cone" <james.cone...@comcast.netXXX> wrote:
> Type AverageIf into the "help" box in Excel, what you get depends on your
> Excel version.
> If you get nothing then go back to the basics: Average = Sum of the
> Items/Number of Items...
>
> =SUMIF(C2:C100,"tardiness",B2:B100)/COUNTIF(C2:C100,"tardiness")
> --
> Jim Cone
> Portland, Oregon USAhttp://www.contextures.com/excel-sort-addin.html
> .
> .
> .
>
> "Jimbo" <warblade...@hotmail.com>
> wrote in messagenews:i4hogi$b5d$(E-Mail Removed)...
> Thank you so much Jim!
> this is a great start, do you have any ideas on how to get the average
> instead of the sum? I'm not sure if there is an "averageif" function.
>
> "Jim Cone" <james.cone...@comcast.netXXX> wrote in message
>
> news:i4hnnl$9e3$(E-Mail Removed)...
>
>
>
> > Use the SumIf function, check out Excel help for the details...
> > =SUMIF(C2:C100,"tardiness",B2:B100)
> > --
> > Jim Cone
> > Portland, Oregon USA
> >http://tinyurl.com/ExtrasForXLadd-in
>
> > .
> > .
> > .
>
> > "Jimbo" <warblade...@hotmail.com>
> > wrote in
> > messagenews:i4hmpn$73i$(E-Mail Removed)...
> > I hope i can make this make sense.
> > I have a spreadsheet that I've merged multiple sheets into. going down
> > the
> > sheet there are multiple cells that have the same label, and adjacent to
> > that label in the next cell is a number. So I might have in C14 the word
> > tardiness and in B14 will be a score, like "4". now this gets repeated
> > all
> > the way down, so maybe C42 we'll find tardiness again, and in B42 we'll
> > have
> > a 2, etc. What I'd like to do is have the average of everything labeled
> > "tardiness" to be placed in cell H2. Where do I even start? I'll have to
> > do
> > this with multiple labels and values.- Hide quoted text -
>
> - Show quoted text -

Change to suit and ARRAY enter (ctrl+shift+enter)
=AVERAGE(IF((A2:A22="a"),B2:B22))