• 580K Members
• 4,870 Online
• 702K Conversations
SOLVED

Highlighted
New Contributor

# Sum every second cell in a column

Hi,

Is there an easy way to sum every second value/cell in a column?

I have a column with 1425 rows, and would line to sum every second cell, i.e. every even numbered cell, and also sum every odd numbered cell, except row 1

3 Replies
Highlighted
Solution

# Re: Sum every second cell in a column

For sum of even-numbered rows, you may use:
=SUMPRODUCT(ISEVEN(ROW(A:A))*A:A)
For odd, just change ISEVEN to ISODD.
Highlighted

# Re: Sum every second cell in a column

Many Thanks Twifoo,

That worked a treat!

Highlighted

# Re: Sum every second cell in a column

You're very much welcome!