Summarise multiple sheets

M

micksa

I have a sheet for each day of the month, each sheet has 4 data columns. What
i need is a way to summarise (or auto summarise) all this data into one
seperate file.
 
R

Roger Govier

Hi

Create 2 new sheets and call them First and Last.
Drag these sheets so that they encompass your daily sheets.
Place your Summary sheet outside of this "sandwich"
On Summary sheet enter in cell A2 of that sheet
=SUM(First:Last!A2)
Copy across through B2:D2, then copy A2:D2 down as far as you wish
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summarise data from several worksheets in a workbook 2
Pivot Table 1
Pivot tables 3
SUMIF and INDIRECT reference to tab in other workbook 3
DIV/0 error 5
Consolidating multiple sheets 4
Cell Referencing rows to columns 3
Summarising multiple worksheets onto one sheet 2

Top