Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Sum every other row

Options
Constance
Constance
edited 12/09/19 in Archived 2017 Posts

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)

 

Tags:

Comments

This discussion has been closed.