Add the Same Cell from Multiple Excel Worksheets to a Summary Sheet
Question details
Combine the corresponding cell from five worksheets on a summary sheet, either by adding numbers or joining text.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A workbook has five source worksheets and a summary sheet that should display a combined result for each corresponding cell.
- Observed behavior
- The summary sheet should show either the numeric total or the combined text from the matching cells on the five worksheets.
Check the names of the five source worksheet tabs and decide whether you need a numeric total or joined text. The examples use Table1 through Table5 and cell A1; replace these names and references with your own.
Sum matching cells from five Excel worksheets
Use SUM to add numeric values from the same cell on each source sheet.
Open the summary worksheet and click cell A1, or the cell where you want the first total.
In the selected cell, enter =SUM(Table1!A1,Table2!A1,Table3!A1,Table4!A1,Table5!A1) and press Enter.
Drag the cell's fill handle across and down to calculate totals for the corresponding cells in the other worksheets.

Join matching text cells from five Excel worksheets
Use CONCATENATE when you want to combine text rather than add numbers.
Create a Multi-Sheet Summary in WPS Spreadsheet
Use cross-sheet formulas in WPS Spreadsheet to add numbers or join text from matching cells on a summary sheet.
- 1. Open the workbook: Open WPS Spreadsheet and select Open to load the workbook containing the source worksheets.
- 2. Choose a summary cell: Click the summary worksheet tab, then select cell A1 or your preferred starting cell.
- 3. Enter a formula: For numbers, enter =SUM(Table1!A1,Table2!A1,Table3!A1,Table4!A1,Table5!A1). For text, use CONCATENATE with the same cell references. Replace the example sheet names as needed and press Enter.
- 4. Fill the summary range: Drag the formula cell's fill handle across and down to combine the corresponding cells from each source worksheet.

Frequently Asked Questions
How do I add the same cell from several Excel sheets?
On the summary sheet, enter a SUM formula such as =SUM(Table1!A1,Table2!A1,Table3!A1) and include each source sheet you need.
When can I use a 3D reference instead of listing every sheet?
Use a formula such as =SUM(Table1:Table5!A1) when the source sheets are consecutive tabs. Excel includes every worksheet between Table1 and Table5 in the total.
How do I add spaces or commas between combined text values?
Insert separators as text arguments in the formula. For example, =CONCATENATE(Table1!A1,", ",Table2!A1) puts a comma and space between the two values.
What if a worksheet name contains spaces?
Enclose the worksheet name in single quotation marks in the formula, as in ='Sales January'!A1. Use that reference inside SUM or CONCATENATE.
Can I use the formula for an entire range?
Yes. Enter the formula in the first summary cell, then drag its fill handle across and down. Relative references such as A1 adjust to match each destination cell.




