Sum every Nth Row (almost working)


D

djforgone

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.
 
Ad

Advertisements

C

Claus Busch

Hi,

Am Fri, 9 May 2014 00:28:50 -0700 (PDT) schrieb (e-mail address removed):
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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top