ExcelBanter - Excel help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel help (https://www.excelbanter.com/excel-worksheet-functions/226403-excel-help.html)

sofdog

Excel help

=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

Jacob Skaria

Excel help

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

Gord Dibben

Excel help

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

All times are GMT +1. The time now is 05:53 AM.