Time for some more Friday Formula Fun. Today we are looking at the good old SUM function, but we are going to use it to SUM the values from the same cell in multiple Excel worksheets.
What does that mean?.
Have you ever had the same cell value on multiple Excel sheets in the same workbook, for example having Sales on each sheet, being an individual monthly report, but being combined into one one Summary worksheet?.
We can quickly and easily SUM all of the months into the summary sheet by using SUM and a couple of extra key strokes.
- Select the cell that will contain your Summary Values, in this case it is C3 on the Yearly Summary Sheet and type =SUM(
- Select the tab of the first sheet to SUM in this case it is JAN.
- Hold down the SHIFT key and select the last sheet to SUM. In this example it is MAR.
- Select the cell to SUM in this case it is C3 the same cell address on all our sheets).
- Close the parentheses on your formula and hit Enter
Your formula will look something like this
The formula has summed all of the values in the range JAN:MAR! which is all of the values from cells C3 in all of the sheets JAN, FEB and MAR. Clever? A quick, easy and accurate way to sum the same cell address on multiple sheets.
Dont forget to sign up to the Excel at Excel Newsletter for 3 free Excel tips the first Wednesday of the month. Just click on the Sign Up Form to the right or use the link below.