Add 12 different totals.

Question

how to set a formula to add totals of 12 different totals?

Answer 1

To set a formula to add totals of 12 different totals in Excel, you can use the SUM function. Here’s how you can do it:

1. Identify the Cells: Determine the cells that contain the 12 different totals you want to add. For example, if your totals are in cells A1 to A12, you will reference these cells in your formula.
2. Use the SUM Function: In a new cell where you want the total to appear, enter the formula:

      =SUM(A1:A12)
   

   This formula will sum all the values from cell A1 to A12.
3. Adjust as Necessary: If your totals are in non-contiguous cells, you can specify each cell individually, like this:

      =SUM(A1, A3, A5, A7, A9, A11, B2, B4, B6, B8, C1, C3)
   

   Replace the cell references with the actual locations of your totals.
4. Press Enter: After typing the formula, press Enter, and the cell will display the total of the specified cells.

This method allows you to easily calculate the sum of multiple totals in Excel.