Thread
:
Average with Date Criteria Error
View Single Post
#
1
Posted to microsoft.public.excel.misc
diaare
external usenet poster
Posts: 50
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
Reply With Quote
diaare
View Public Profile
Find all posts by diaare