Sum every other row

Constance

How do I add up values of all odd or all even rows? 

I've tried

=SUMWIN(WIN1:WIN119,MOD(ROW(WIN1:WIN119)+1,2))

but it didn't work (WIN is the title of the column)

 

rjudenberg

there is no row number function in smartsheets (there's also no mod function, btw)

you might try creating another column with a checkbox, and summing the rows where the checkbox is checked or unchecked.

=SUMIFf(CHECKBOX1:CHECKBOX119,=1,WIN1:WIN119)

If you are insistent on odd/even, you could create a column with row numbers see https://community.smartsheet.com/discussion/formula-determine-row-number?_ga=2.214206103.1028967354.1509986821-1501603503.1503930282 

then assuming new column ROW

=SUMIFf(ROW:ROW119,@cell/2 = int(@cell/2),WIN1:WIN119) for even (change to <> for odd)

J. Craig Williams

Be careful of solutions for this (mine or anyone else's) if you or your users move rows around or delete them. It tends to mess up the formula references (by design, I'm not implying this is a bug, it is just a known issue with solutions like this)

For a check box column (named CheckBox), this formula

=NOT([CheckBox]1) 

in row 2 and then copied to the rest of the column (but not row 1), will check alternate rows.

Craig