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.

 

image

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
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