# Get row totals

To get row totals of a range that contain numeric values, use the TOTALROW function or a custom formula with the MMULT function.

## How to get row totals of a range?

1. Type the =TOTALROW(range) formula in cell H3.
2. Press Enter.
3. The formula sums each row in the selected range.

The TOTALROW function uses a single, required argument, the range where we find the rows.

``=TOTALROW(range)``

### Example

In the example, the data is in the range C3:G9. First, create a named range. Select the range, click the name box and type “Sales”. From now on, “Sales” refers to the range C3:G9.

Formula:

``=TOTALROW(sales)``

The formula will return the sum of each row in the selected range.

Note: TOTALROW is a dynamic array function, so the result spills into a range, not a single cell. The function is compatible with all Excel versions. If you are working with a different version of Microsoft 365, press Ctrl+Shift+Enter to create the output array.

### Get row totals with the MMULT function

Now let us see the workaround with the MMULT and row functions.

Generic formula to get row totals:

``=MMULT(--range,TRANSPOSE(COLUMN(range)^0))``

Apply the formula in cell H3:

``=MMULT(--Sales,TRANSPOSE(COLUMN(Sales)^0))``

Evaluate the formula from the inside out:

``=COLUMN(Sales)^0``

The ^0 operator raises each number in the array to the power of 0. When a number is raised to the power of 0, the result is always 1. After that, the formula creates an array the same size as the original.

``=TRANSPOSE(COLUMN(Sales)^0)``

The TRANSPOSE function transforms a horizontal array into a vertical array.

``=--Sales,TRANSPOSE(COLUMN(Sales)^0))``

The MMULT function uses numeric values, so we need to use the double negative method to convert boolean values to 0s and 1s. For example, if the cell contains a number, the value is 1, else 0.

Finally, the MMULT function sums the values in each row of the selected range, resulting in an array of row totals.

### Using the SEQUENCE function

Generic formula:

``=MMULT(--Sales, SEQUENCE(COLUMNS(Sales), 1, 1, 0))``

You can use the SEQUENCE function to create an array with the same column size as the “Sales” range.

``=SEQUENCE(COLUMNS(Sales), 1, 1, 0)``

The SEQUENCE function uses four arguments:

• The no. of columns in the array.
• The no. of rows in the array: 1
• The starting value in the array: 1
• Step: 0

The double-negative method converts boolean values to 0s and 1s. Finally, the MMULT function multiples the “Sales” array and sums values in the “Sales” range. 