HOW TO SUM EVERY OTHER COLUMN
 

HELLO,
I HAVE A LARGE SHEET COLUMNS RANGING FROM D TO WV. I WANT TO SUM EVERY OTHER COLUMNS. PLS HELP ME
THANKS

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.

HOW TO SUM EVERY OTHER COLUMN
 

Then the desired result should be
=SUMPRODUCT(D1:WV1, D7:WV7)

Correction: better would be
=SUMPRODUCT(D1:WV1,D$7:WV$7)Â*