SOLVED
Home

Sum every second cell in a column

Stev05163
New Contributor

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
Solution
For sum of even-numbered rows, you may use:
=SUMPRODUCT(ISEVEN(ROW(A:A))*A:A)
For odd, just change ISEVEN to ISODD.

Many Thanks Twifoo,

That worked a treat!

You're very much welcome!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies