|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 3rd, 2008, 02:21 PM
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:G210,G17:G21,"")) in M11 that is just calculating numbers and it works fine. However, I put a similar function of =AVERAGE(IF(G22:G250,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
September 3rd, 2008, 02:47 PM
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:G210,G17:G21,"")) in M11 that is just calculating numbers and it works fine. However, I put a similar function of =AVERAGE(IF(G22:G250,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
September 3rd, 2008, 08:34 PM
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:G210,G17:G21,"")) in M11 that is just calculating numbers and it works fine. However, I put a similar function of =AVERAGE(IF(G22:G250,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...
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
