ExcelBanter - sum alternate rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sum alternate rows (https://www.excelbanter.com/excel-worksheet-functions/147003-sum-alternate-rows.html)

anand

sum alternate rows

is there a formula that allows you to sum alternate rows (even vs odd) or
similar? Can this be done with a variation of the "sumif" function?

anand

Max

sum alternate rows

One way ..

In say, B1:
=SUMPRODUCT(--(MOD(ROW(A1:A10),2)=1),A1:A10)
returns the sum of the odd rows within the range A1:A10,
viz the sum of: A1, A3, A5, A7, A9

=SUMPRODUCT(--(MOD(ROW(A1:A10),2)=0),A1:A10)
returns the sum of the even rows within the range A1:A10,
viz the sum of: A2, A4, A6, A8, A10
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"anand" wrote:
is there a formula that allows you to sum alternate rows (even vs odd) or
similar? Can this be done with a variation of the "sumif" function?

anand

anand

sum alternate rows

Don't worry about it. Found it. Please ignore question

anand

Jovan Timotijevic[_2_]

sum alternate rows

To sum cells A1:A7 that are

EVEN: =SUM(IF(MOD(ROW(A1:A7),2)=0,A1:A7,0))
ODD: =SUM(IF(MOD(ROW(A1:A7),2)=1,A1:A7,0))

Ctrl+Shift+Enter to enter formula

Max

sum alternate rows

Durn it, too late <g. The shot's fired.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"anand" wrote:
Don't worry about it. Found it. Please ignore question

anand

All times are GMT +1. The time now is 02:40 PM.