Function works in one cell but not another

  • Thread starter Thread starter myssieh
  • Start date Start date
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...
 
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

IF THEN statement error 6
how do I create a formula in excel with using 2 columns of info? 1
How do I average cells that contain #DIV/01? 2
Is there a function to show if cell/row(X:Y) is hidden? or width? 3
Sumif Function 2
more than 7 nested IF(AND) statements in formula - VBA? **NEWBIE** 3
IF statement on a range of cells in Excel 2007 4
VLookup 4

Back
Top