June 30, 2012

How to sum a cell with another cells in different worksheets

Problem: To sum cells from another sheets in Excel

 Formulae for the example shown on picture is:

to sum sheets named after months- in this example with cells to be summed are found at A1 address, and result to be displayed in first sheet (that's why it's called A1 - it doesn't have January in name)

If we want sum to be displayed in new sheet, the same formulae would be:

or with cells we want to calculate are found at A1:

No comments: