View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] djforgone@gmail.com is offline
external usenet poster
 
Posts: 3
Default Sum every Nth Row (almost working)

Hi All,

Need some assistance here...

This formula works...

{=SUM(IF(MOD(COLUMN(D11:OFFSET(D11,0,0,1,36)),3)=0 ,D11:OFFSET(D11,0,0,1,36)),0)}

Except... it's not working exactly the way I want.

I need to Sum ever 3rd column but I want it to start with the first column in the range.

EG:

Columns D, G, J
Whereas it is summing up F, I & L

Any assistance to work this out would be wonderful.