Add Same Cell From Each Sheet

  • Thread starter Thread starter Jambruins
  • Start date Start date
J

Jambruins

I would like to find the sum of cell H2 from each sheet (there are 10
sheets). What function do I use for this?

For example, I want sheet 1 cell H2+sheet 2 cell H2+sheet 3 cel
H2+...+sheet 100 cell H2=?

Thank you
 
On any cell/sheet outside that range (Must not be in H2 in any sheet between
first and last sheet in your range) use

=SUM('Sheet 1:Sheet 100'!H2)
 
I would like to find the sum of cell H2 from each sheet (there are 100
sheets). What function do I use for this?

For example, I want sheet 1 cell H2+sheet 2 cell H2+sheet 3 cell
H2+...+sheet 100 cell H2=?
Click to expand...

Go to the worksheet where you want the answer to be; in a relevant
cell type '= Sum(' then highlight all worksheets whilst still in the
forulae mode (by clicking on the 1st, Shift and click on the last ...
this should highlight all your worksheets) then click on the cell to
be added (H2) then Enter (the closing bracket will automatically be
entered).

You should end up with a formuale like SUM(Sheet1:Sheet100!H2)
 
Back
Top