CONSOLIDATE SHEETS

[Roger]

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.

 

[Jacob Skaria]

Try

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

If this post helps click Yes