View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
diaare diaare is offline
external usenet poster
 
Posts: 50
Default Average with Date Criteria Error

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