Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parenthese Error
Can anyone assist in the formula below? I think I'm missing a parenthese
because I'm not getting the correct result. =IFERROR(SUM(OFFSET(Data!$J$1,2,0):OFFSET($J$1,38, 0))/SUM(OFFSET(Data!$I$1,2,0):OFFSET(Data!$I$1,38,0)), ) Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parenthese Error
On Mar 26, 11:13*am, SMH wrote:
Can anyone assist in the formula below? *I think I'm missing a parenthese because I'm not getting the correct result. =IFERROR(SUM(OFFSET(Data!$J$1,2,0):OFFSET($J$1,38, 0))/SUM(OFFSET(Data!$I$1,*2,0):OFFSET(Data!$I$1,38,0)) ,) Thanks! First thing: I'm assuming you're using XL 07? IFERROR is not available in older versions of XL. Second: try this: =IFERROR(SUM(OFFSET(Data!$J$1,2,0):OFFSET($J $1,38,0))/SUM(OFFSET(Data!$I$1,2,0):OFFSET(Data!$I$1,38,0)) Dave |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parenthese Error
Oh thank you so much!! I'm not sure what you gave me vs what I was doing,
but it worked!! "Dave F" wrote: On Mar 26, 11:13 am, SMH wrote: Can anyone assist in the formula below? I think I'm missing a parenthese because I'm not getting the correct result. =IFERROR(SUM(OFFSET(Data!$J$1,2,0):OFFSET($J$1,38, 0))/SUM(OFFSET(Data!$I$1,Â*2,0):OFFSET(Data!$I$1,38,0) ),) Thanks! First thing: I'm assuming you're using XL 07? IFERROR is not available in older versions of XL. Second: try this: =IFERROR(SUM(OFFSET(Data!$J$1,2,0):OFFSET($J $1,38,0))/SUM(OFFSET(Data!$I$1,2,0):OFFSET(Data!$I$1,38,0)) Dave |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parenthese Error
Well, you haven't told us what data you have, what result you are getting,
or what result you expected. One interesting point is that the range specified for your first SUM seems to start on your Data sheet but finish on the current sheet. You've used the Excel 2007 IFERROR function but haven't specified what to do if the error is encountered. What happens if you remove the IFERROR and just use =SUM(OFFSET(Data!$J$1,2,0):OFFSET($J$1,38,0))/SUM(OFFSET(Data!$I$1,2,0):OFFSET(Data!$I$1,38,0)) [correcting the data ranges if appropriate]? You specify the start and end points of your SUM ranges with separate OFFSET functions, but couldn't you use OFFSET to specify the range? in other words, couldn't you replace SUM(OFFSET(Data!$I$1,2,0):OFFSET(Data!$I$1,38,0)) by =SUM(OFFSET(Data!$I$1,2,0,37,1)) If you are struggling to understand what your parentheses are doing, why not break down the formula to manageable chunks? Try the first SUM as one formula, the second SUM as a second formula, and see whether each of those gives you the result you expected, then you can do the divide. -- David Biddulph "SMH" wrote in message ... Can anyone assist in the formula below? I think I'm missing a parenthese because I'm not getting the correct result. =IFERROR(SUM(OFFSET(Data!$J$1,2,0):OFFSET($J$1,38, 0))/SUM(OFFSET(Data!$I$1,2,0):OFFSET(Data!$I$1,38,0)), ) Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
splitting text within parenthese into new column | Excel Worksheet Functions |