=AVERAGEIF('BK Data'!V6:'BK Data'!V73,"=*Y",'BK Data'!S6:'BK Data'!S73)
when I use this formula in 2003 version it returns the value Name, but
when i use it on 2007 it is fine. D

Can you provide more info about the data
--
If this post helps click Yes
---------------
Jacob Skaria


"sofdog" wrote:

=AVERAGEIF('BK Data'!V6:'BK Data'!V73,"=*Y",'BK Data'!S6:'BK Data'!S73)
when I use this formula in 2003 version it returns the value Name, but
when i use it on 2007 it is fine. D

Did you look for AVERAGEIF in 2003 help?

You will find it does not exist.................2007 function only.


Gord Dibben MS Excel MVP

On Wed, 1 Apr 2009 20:50:05 -0700, sofdog
wrote:

=AVERAGEIF('BK Data'!V6:'BK Data'!V73,"=*Y",'BK Data'!S6:'BK Data'!S73)
when I use this formula in 2003 version it returns the value Name, but
when i use it on 2007 it is fine. D