Consolidated results across worksheets with Row ans Column remain same

Hi,

This is tremor here. I am new to this forum and I am facing problem in creating formula for following action.

I have a worksheet with four sheets. Three are monthly and one is Quarterly. All sheets have same row and column.
How can I get consolidated results in 'Quarter 1' tab using formula.

Thanks a lot

TrEmOr
^_^

Put this formula in cell B2 of Sheet4:

=SUM(Sheet1:Sheet3!B2)

then copy across and down as required.

Hope this helps.

Pete

Perhaps this formula; it adds the values in B2 across sheet1 to sheet3

Formula:

Please Login or Register  to view this content.

Thanks