How to sum a column in excel spreadsheet

If not, the single quotes can be left out. If your worksheet names contain spaces, or are the name of a range (e.g., Q1 could be the name of a sheet or a cell reference ), then single quotes ( вЂ ) are required around the sheet names. Replace FirstSheet and LastSheet with the worksheet names you wish to sum between.To sum the same cell across multiple sheets of a workbook, we can use the following formula structure: =SUM('FirstSheet:LastSheet'!A1) ThatвЂ™s why IвЂ™m sharing it here by using this approach, you can look like an Excel genius to your work colleagues too рџ™‚ SUM across multiple sheets вЂ“ basic

I still remember the first time a work colleague showed me this trick my jaw hit the ground in amazement. The good news is that there is another approach we can take that will enable us to sum across different sheets easily. And just think about the time you will waste if there is a new tab to be added. The chances are that you donвЂ™t need to do all that clicking. How do you know if youвЂ™ve clicked on every worksheet? What if you happened to miss one by accident? There is only one way to know вЂ“ youвЂ™ve got to check it! The formula in cell C5 is: =Jan!C5+Feb!C5+Mar!C5+Apr!C5+May!C5+Jun!C5+ The screenshot below shows an example of this type of approach. Also, if the sheet names are long, the formula starts to look quite unreadable. If there are a lot of worksheets, it takes a while to click on them all.

I see many examples where the user has clicked the same cell on each sheet, putting a вЂњ+вЂќ symbol between each reference. For example, it could be a monthly report with a tab for each month (see screenshot below as an example). Have you ever had to sum the same cell across multiple sheets? This often occurs where information is held in numerous sheets in a consistent format.

How to sum a column in excel spreadsheet