J
Jim
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
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