Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Really strange issue with simple formula
I have a formula I've successfully used in a spreadsheet for over seven
years in the USA (spanning multiple users and Excel versions). A group in Belgium is now trying to use it, and getting an "Error in formula" error. They have the exact same computer set up we use (Excel 2003), yet the formula doesn't work over there. They have tried on several machines. Anyone know why this might be? Or any debugging strategies? Any insight or guesses at all? Details... Where SerArea is named dynamic named range in column A. Where LetIdNum is a named cell (value is "D") The variable syntax is this: =COUNTIF(SerArea,INDIRECT(LetIdNum&ROW()))1 That gets the error when entering it ONLY in Belgium. Without variables, it would evaluate to this simple syntax: =COUNTIF(A1:A18,D2)1 Funny thing, when entered in that simple format in Belgium, it WORKS. Then, in Belgium, we replace a constant for a variable and it still works: =COUNTIF(A1:A18,INDIRECT(LetIdNum&ROW()))1 Then, in Belgium, we replace the last constant to a variable and it still works: =COUNTIF(SerArea,INDIRECT(LetIdNum&ROW()))1 Guess what? NOW, it's been edited back to the original syntax it refused to accept before. It threw an error when we put it in directly like that, but when we put it in as simple syntax and then edit it to this it works. Is that crazy or what? Any helpful comments would be great because I need the variable version of the syntax to work like it has here in the States for so many years. Thanks, Chuck |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula issue | Excel Discussion (Misc queries) | |||
Simple Excel Formula Help | New Users to Excel | |||
Strange behavior in INDEX(..., MIN(...)) - array formula | Excel Discussion (Misc queries) | |||
simple formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |