If you are using Excel2007, you may try:
=AVERAGEIFS(C1:C100,A1:A100,"John Doe",B1:B100, "3/31/09",B1:B100,"<4/16/09")
Please advise if this helps.
RoadKill wrote:
How can I try to do an average requiring multiple criteria? For example, I
want to do it by Employee Name and Date Range.
So if cells A1:A100 is the Name, B1:B100 is the Date and C1:C100 is the
score to be averaged, how can I have it pull an average for John Doe for
April 1-15th?
Thank you
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200904/1