| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function works in one cell but not another
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... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function works in one cell but not another
Maybe there is a #VALUE! somewhere within G22:G25 ?
-- Max Singapore http://savefile.com/projects/236895 Downloads:17,700 Files:359 Subscribers:55 xdemechanik --- "myssieh" wrote: 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... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function works in one cell but not another
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 "myssieh" wrote: 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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can someone test this IF function for me, I'm not sure that it works. | Excel Worksheet Functions | |||
| SMALL FUNCTION - How it works | Excel Discussion (Misc queries) | |||
| referencing active cell works in a sub but not in a custom function | Excel Worksheet Functions | |||
| referencing active cell works in a sub but not in a custom function | Excel Worksheet Functions | |||
| Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
Linear Mode
