View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf[_3_] MyVeryOwnSelf[_3_] is offline
external usenet poster
 
Posts: 56
Default 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.