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...
 
Ad

Advertisements

Ad

Advertisements

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

Top