Do you have non-dates (or non-numeric) data in ac9:ac74?

If you have strings you can't change, maybe:

=AVERAGE(IF(text(AC9:AC74,"yyyy")="2008",AD9:AD74) )

diaare wrote:

Could someone please help me figure out why the following formula is
producing a #value error?

=AVERAGE(IF((YEAR(AC9:AC74)=2008),AD9:AD74))

I entered it as an array as well.

Thanks,

Diane

--

Dave Peterson