•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
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#row zero
#rows.com
#AI formula generation techniques
#formula generator
#financial modeling with spreadsheets
#Excel
#SUM
#formulas
#table
#rows
#F31:I31
#F33:I33
#F35:I35
#F37:I37
#F39:I39
#F41:I41
#F43:I43