Thread: HOW TO SUM EVERY OTHER COLUMN
View Single Post
  #3   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

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

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