Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old 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
Default Please help me win my fantasy football league by answering this excel ?

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   Report Post  
Old 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
Default Please help me win my fantasy football league by answering this ex

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
need help setting up our fantasy football league schedule THawk Excel Discussion (Misc queries) 2 August 29th 06 09:33 PM
Fantasy Football Conditional Arrays altopalo Excel Worksheet Functions 4 May 8th 06 05:08 AM
Fantasy Football tuggers Excel Discussion (Misc queries) 0 April 19th 06 06:31 AM
Fantasy Football dibster Excel Discussion (Misc queries) 1 July 9th 05 07:13 AM
Fantasy Football dibster New Users to Excel 0 July 8th 05 09:59 PM


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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017