Thread: Sum every Nth Row (almost working)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Sum every Nth Row (almost working)
Hi,

Am Fri, 9 May 2014 00:28:50 -0700 (PDT) schrieb :

Columns D, G, J

if you want to sum D11+G11+J11 try:
=SUM(IF(MOD(COLUMN(D11:J11),3)=1,D11:J11))
and enter the formula with CTRL+Shift+Enter

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote