In this article, we will learn how to sum the data from a cell in a number of sheets.We use the Sum function with 3D reference in Microsoft Excel 2010.

**SUM:**This function is used to add the numbers in a range of cells.

**The syntax of SUM formula:- =SUM(number1,number2,……)**

Let’s take an example to understand how we can add the numbers for rows.

We have sales data in range A1:A10. Now, we want to return the totalvalue.

Follow below given steps:-

*Select the cell A11.**Write the formula.*- =SUM(A2:A10), and
*press Enter on your keyboard.* *The function will return the total value.*

Let’s take an example and understand how we can add the data values from the different sheets.

In this example, we have a workbook with four successive sheets: January, February, March and Total.

In every sheet, we have sales data month wise. Column A contains Agent name, column B contains country name and column C contains Sales amount.

In the total sheet, we want to return the total amount of every agent in Column C.

Follow below given Steps:-

- Select the cell C2 in Total’s sheet.
- Write the formula.
- =SUM( , select the tab for the first sheet, January.

- Hold the Shift key and then select the tab for the last sheet, March.
- Select cell B2, and then press Enter on your keyboard.
- The Formula is now =SUM(January:March!C2).

- The function will return the total sales amount for HOYT in cell C2.

- To return the total sales amount for every agent, copy the same formula by pressing the key Ctrl+C and paste in the range C3:C10 by pressing the key Ctrl+V on your keyboard.

This is the way you can get the sum of the data from a cell in a number of sheets in Microsoft Excel.