标签:How to Sum Every Other Column in Excel
-
How to Sum Every Other Column in Excel?
In our last tutorial, we learned the way of how to sum every other row in Excel. Let’s continue this in the second part, knowing how to sum every other column in Excel. Here is a random number table. Let’s get the sum of the odd columns as the screenshot below first. Type this =SUMPRODUCT((MOD(COLUMN(A1:G10),2)=1)*A1:G10) […]