Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelHow to Sum Alternate Rows/Columns cell values in Microsoft Excel ?

# How to Sum Alternate Rows/Columns cell values in Microsoft Excel ?

There are times when you would have come across a scenario where you need to sum up the value of every other alternate row. You can easily do that in Microsoft Excel 2016 by using the SUMIF formula.

# How to Sum Alternate Rows/Columns cell values in Microsoft Excel 2016 ?

The SUMIF function calculates the sum of a range of data that meets the specific criteria. In our case , we are concerned with the odd rowâ€™s value.

Hereâ€™s how you do it.

Assume that the values are defined in the cell F6 to F11 and you need to find the sum of alternate or odd rows i.e F6+F8+F10.

First , add the values 1 to the next column for the cells G6 , G8 and G10 and then add the values 0 to G7 , G9 , G11.

Apply the formula

=SUMIF(G6:G11,1,F6:F11)

You should see the result in the cell where the formula is applied.

Â

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021