HOW TO SUM EVERY OTHER COLUMN
I HAVE A LARGE SHEET COLUMNS RANGING FROM D TO WV.
I WANT TO SUM EVERY OTHER COLUMNS. PLS HELP ME
THANKS
Maybe something like this would help.
Find an unused out-of-the way row. I used row 7.
In D7, put
=--ISODD(COLUMN())
And copy rightward to WV7
Then the desired result should be
=SUMPRODUCT(D1:WV1, D7:WV7)
If you want to start the sum in column E rather than D, use ISEVEN instead of ISODD.
The extra row can be hidden to avoid clutter.
|