Hi Stefi

This is the formula

=SUM(INDIRECT(+("R5C"&COLUMN(INDEX(AA9:CB9,MATCH(9 .99999999999999E+307,AA9:CB9)))&":R5C")&COLUMN(IND EX(AA9:CB9,MATCH(9.99999999999999E+307,AA9:CB9))), FALSE))

When in Evaluate the formula (before the error in French) it's giving me
SUM(INDIRECT(R5C45:R5C45",FALSE))

If you need more information, let me know

Thanks for you help
"Stefi" a écrit dans le message de
...
You should post the Indirect formula!
--
Regards!
Stefi



€žcatherine€� ezt Ã*rta:

Hi,

I read in a post on this site (by Niek Otten in July 2009)that we can
have
problem with the Indirect function in Excel when we work with people with
other languages.

My collegue work with Excel 2003 in English and when he use the Indirect
function, he don't have any error. If I open the same file on the
network in
Excel 2003 in French, I see #Ref! error?

Can I modify something to don't see the error?

I have already change my regional setting to English and I don't have any
more idea

I am using Windows XP SP3 in French with Excel 2003 SP3 in French. My
collegue is working with Windows XP SP3 in English with Excel 2003 SP3 in
English.

Thanks,
Catherine