Excel help

S

sofdog

=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
 
G

Gord Dibben

Did you look for AVERAGEIF in 2003 help?

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Sumproduct searching cell contents 2
Averageif function with range that includes non-consecutive cells 4
Excel 2007 - AVERAGEIF on rows that are non-continuous 2
Weighted Average 7
Index formula with IF condition 1
Complex Nesting 4
Help with Workbook name change on update 1
Help in changing code to see new file name (Dave Peterson) 3

Top