Remember Me?

#1
June 29th 07, 08:35 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2007 Posts: 1

Thanks in advance for any help. Here is my challenge. I want to
track stats for players on rows. Have a different row for each of the
last three seasons (They are in the same columns so I can data sort
and all of player x's stats for the lest three seasons are in three
rows. How do I get Excel to recognize that the value (a-z) in the
name field matches and THEN average together one cell from each of the
three rows.

e.g. 06 Jo Johnson 48
05 Jo Johnson
57

How do I write one cell that excel will know is asking me to average
all of the number values if the names match?

I am a rookie so if this one is obvious I apologize.

NJD

#2
June 29th 07, 09:12 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 11,501

Hi Nicholas,

If I understand correctly you have a column of names of players (Col B) and
a column of stats (Col C)

This formula looks down Column B and works out the average of all Jo
Johnson's stats. There's no need to sort the players names.

=SUMIF(B1:B100,"=Jo Johnson",C1:C100)/COUNTIF(B1:B100,"Jo Johnson")

Mike

" wrote:

Thanks in advance for any help. Here is my challenge. I want to
track stats for players on rows. Have a different row for each of the
last three seasons (They are in the same columns so I can data sort
and all of player x's stats for the lest three seasons are in three
rows. How do I get Excel to recognize that the value (a-z) in the
name field matches and THEN average together one cell from each of the
three rows.

e.g. 06 Jo Johnson 48
05 Jo Johnson
57

How do I write one cell that excel will know is asking me to average
all of the number values if the names match?

I am a rookie so if this one is obvious I apologize.

NJD

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post THawk Excel Discussion (Misc queries) 2 August 29th 06 09:33 PM altopalo Excel Worksheet Functions 4 May 8th 06 05:08 AM tuggers Excel Discussion (Misc queries) 0 April 19th 06 06:31 AM dibster Excel Discussion (Misc queries) 1 July 9th 05 07:13 AM dibster New Users to Excel 0 July 8th 05 09:59 PM

All times are GMT +1. The time now is 01:31 PM.