Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default If the average

Hello,

In cell A1 I would like to put a month and year, for this example we can use
December 08, but I would also like to be able to change it to January 08 and
match the dates in the range of column D

In Cell B1 I have a name, for this example we can use Jim

In Cell C1 I will return the results of the formuls (you fill this in)

Column D has a variety of dates from January 01 2001 to December 31 2008

Column E has various names including the match we are looking for "Jim"

Column F has data generally looking like this: .41

Can you help me with a formula that will take all the the data entries
(column F) that match Jim (column E) for December 08 and average them.

If December 08 had 20 entries for Jim in column F then take the data add it
all together and divide it by 20.

I hope this is clearer than mud.

Thank you very much you "Excel Yoda's"

Jim
 
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
A formula to AVERAGE IF but only average a set number of values [email protected] Excel Worksheet Functions 2 January 31st 08 08:28 PM
Find monthly average but have average automatically configured kimbafred Excel Discussion (Misc queries) 2 August 8th 07 12:28 AM
Error Handling #N/A with AVERAGE Function - Average of values in Row Sam via OfficeKB.com Excel Worksheet Functions 13 July 31st 05 03:59 PM
Weighed Average of a weiged average when there are blanks krl - ExcelForums.com Excel Discussion (Misc queries) 1 July 6th 05 07:37 PM
how does one convert text to a formula "average(A:A)" to =average( phshirk Excel Worksheet Functions 4 April 14th 05 01:20 AM


All times are GMT +1. The time now is 02:58 AM.

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

About Us

"It's about Microsoft Excel"