Summing same cell/cells from multiple sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a report with a summary sheet which will contain the totals of
many subsheets. I have seen a formula that sums the same cell from multiple
sheets without having to go to each sheet and do a formula like +"cell
refernece"+"cell refernece".... I can not remeber the formula.

Any help is apprecaited
Thanks
 
Try

=SUM(first:last!A10)

apply as follows:
type equal sign, select the first sheet that you want to be included, hold
down shift key and select the last sheet, click in the cell
you want to sum, press enter.
 

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

summing same cell in multiple worksheets 3
Copying cells from one sheet to another 5
Automatic Sumning of Same Cell from Different Sheets 3
Summing multiple validated sheets into a summary sheet 3
sum values from the listed sheets 9
INDIRECT with Sheet Level Defined Name 2
SUM function on multiple worksheet 5
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7

Back
Top