Function works in one cell but not another

M

myssieh

Good Morning!!
I am running Excel 2003

I have a function of: =AVERAGE(IF(G17:G21<>0,G17:G21,"")) in M11 that is
just calculating numbers and it works fine.

However, I put a similar function of =AVERAGE(IF(G22:G25<>0,G22:G25,"")) in
N11 and it is giving an error of a value used in the formula is of the wrong
data type.

the number it is calculating are very similar so I am confused. Any help
you can provide will be greatly apprecitated...

Thanks again...

Myssie...
 
D

Duke Carey

Are you entering it as an array function?

Select the formula that is generating the error, press the F2 key, then
simultaneously press Ctrl-Shift-Enter
 

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

How do I average cells that contain #DIV/01? 2
how do I create a formula in excel with using 2 columns of info? 1
LOOKUP returning some incorrect values 7
Lessor Of or Greater of Nested Function 1
Problem with SET & REF function 0
Sumif Function 2
Is there a function to show if cell/row(X:Y) is hidden? or width? 3
Automatically sending multiple parts of text from one word doc to another - is possible. 0

Top