From: snake941 on
How do I add formulas from multiple sheets in a workbook to a consolidated
worksheet?
From: Fred Smith on
Maybe something like this:

=sum(sheet1:sheet5!a1)

Regards,
Fred

"snake941" <snake941(a)discussions.microsoft.com> wrote in message
news:C59A8551-9496-4C6F-9F78-E314989B0E99(a)microsoft.com...
> How do I add formulas from multiple sheets in a workbook to a consolidated
> worksheet?