•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to sum every other row in a table?
Hello everyone,
I don’t use Excel very often, so I don’t have much experience with formulas, but i have a basic understanding.
I need to sum every other row in a table. Previously, this was done using the following formula:
=SUM(F31:I31+F33:I33+F35:I35+F37:I37+F39: I39+F41:I41+F43:I43+F45:I45+F49:I49+F51:I51) (this isn’t the whole formula—it continues like this through row 150)
There has to be a better way to sum rows like this.
I use the Newest Excel Version from M365
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com