How does it not work? Are you getting the wrong answer or an error? If an
error, what kind of error?
Are the dates entered as dates but formatted as you've shown, or are they
text? How are you specifying the criteria for the date?


"xrayr" wrote:

I have a spreadsheet with columns of data on sheet 1. I would like to have
the average of column "U" determined ONLY when the corresponding data in
Column "C" equals a certain value (date value shown as: "2005/01/01")

I would like this average shown on another sheet that I have termed "Summary".

I cannot get this to work.

Somebody please help!