Site icon ExcelNotes

How to Sum Numbers in Even Rows

You can use the SUMPRODUCT and MOD functions to have the sum of the numbers in the even rows.

Example: You are working with a worksheet with the product in column A, the amount in column B, and the profit/loss in column C.

Question: What is the sum of numbers in even rows in column B?

=SUMPRODUCT(MOD(ROW(B2:B10)+1,2), B2:B10)

The result returns 2,966.

Explanation:

You can use the following formula to have the sum of the numbers in column C in the even rows.

=SUMPRODUCT(MOD(ROW(B2:B10)+1,2), C2:C10)

The result returns 1,415.55.

Notes: The SUMPRODUCT Function

The SUMPRODUCT function adds all the multiplication results for all arrays.

Formula:

=SUMPRODUCT(array1, [array2], …)

Explanations:

– Array1 is required; the first array is to multiply and add.
– Array2 is optional; the second array is to multiply and add.

Exit mobile version