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