Hmmm...

Works in all my tests:

http://img503.imageshack.us/img503/7786/averagenr1.jpg


--
Biff
Microsoft Excel MVP


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Not sure why, but that counts 2006 values twice when averaging.....

Bernie
MS Excel MVP


"T. Valko" wrote in message
...
Try this:

K4 = 2006

=AVERAGE(IF(('Export and Site View'!$M$2:$M$282=$K$4+{0,1}).......

--
Biff
Microsoft Excel MVP


"PAL" wrote in message
...
I am working on a big array formula that currently works great.

=AVERAGE(IF(('Export and Site View'!$M$2:$M$282=$K$4)*('Export and Site
View'!$C$2:$C$282=$A$2)*('Export and Site
View'!$H$2:$H$282="Active")*('Export and Site
View'!$N$2:$N$2820),('Export
and Site View'!$N$2:$N$282),""))

The first condition = $K$4 references a field with a year (ie. 2007).
How
can I change the condition to reference 2006 and 2007. I am looking to
return
a values that look up two years. Do I have to add an OR Condition? If
so
where?

Thanks.