Can I show totals from sheets 2 &.3 on sheet 1

C

Chezney

I have information on sheets 1, 2, 3,4 etc. Can I collate the totals from
each sheet on a master speread sheet 1?c
 
P

Pete_UK

Suppose your totals are in cell D2 on each of those sheets, and that
the summary sheet is positioned either before Sheet1 or after your
last sheet (i.e. not in the middle of the first and last sheets). Then
you can use this formula to add them all up:

=SUM(Sheet1:Sheetn!D2)

where Sheetn is your last sheet in the sequence.

Hope this helps.

Pete
 

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

Visio: copy text of a master shape to User-define Cells (Variable) 0
Shift Collate sheet 1-20 when printing entire workbook? 0
Section and Page numbering 0
Match and delete rows on two different sheets from reference numbers 4
Grouping {MERGEFIELD} into 2 or 3 Columns 0
Help with a running total on multiple sheets 2
selecting workbook/sheet 3
add hyperlink using sheet names and cells(i,j) 3

Top