I have been trying to consolidate data from various SHEETS using the
following formulas:

=SUM('SRY SAGA 2009 BY SUP':'SRY IBK MC 2009 BY SUP'!C5)

where data in the first and second sheet are exactly identical in format. I
get a NAME error, which I cannot understand.

I have used alternatively this other method:

=SUM('SRY SAGA 2009 BY SUP'!C5,'SRY IBK MC 2009 BY SUP'!C5)

and it worked with this second method.

I want to use the first syntax as it is simpler.

Anyone can help me in determining what is not working in the syntax of the
first expression.

Thanks.

Roger.



--
Roger

Try

=SUM('SRY SAGA 2009 BY SUP:SRY IBK MC 2009 BY SUP'!C5)

If this post helps click Yes
---------------
Jacob Skaria


"Roger" wrote:

I have been trying to consolidate data from various SHEETS using the
following formulas:

=SUM('SRY SAGA 2009 BY SUP':'SRY IBK MC 2009 BY SUP'!C5)

where data in the first and second sheet are exactly identical in format. I
get a NAME error, which I cannot understand.

I have used alternatively this other method:

=SUM('SRY SAGA 2009 BY SUP'!C5,'SRY IBK MC 2009 BY SUP'!C5)

and it worked with this second method.

I want to use the first syntax as it is simpler.

Anyone can help me in determining what is not working in the syntax of the
first expression.

Thanks.

Roger.



--
Roger