Hi Duke.

I'm receiving a #VALUE! error.

The dates are formatted as "2005/01/01" as that is the format that the
system generates.

This is one of the formulas that I have tried:
=DAVERAGE(Sheet1!U2:U465,,"IF+Sheet1!C2:C465='2005/01/01'")

Thank you for your help!

"Duke Carey" wrote:

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!