trying to save some time

[Brown]

Good afternoon,

I am trying to add a string of 60 numbers, all in the same column, but they are all 11 cells apart. What is the easiest way to do the formula =sum( )?
is it best to click on every cell, type all of the cell names, or is there a shortcut you guys know that will help me get all of the cell numbers in the formula quickly?

I hope this is making since.

thanks
Brown

 

[Joe4]

What are the first and last cell addresses you that should be included in the sum?

 

[Brown]

P3

p710

 

[Joe4]

OK, so if you wanted to sum the values from P3, P14, P25, P36, P47, ...
then use this formula:

=SUMPRODUCT(--(P3:P710),--(MOD(ROW(P3:P710),11)=3))

 

[Brown]

awesome thank you very much. I knew that had to be an easier way than clicking on each cell.
Brown

 

[Joe4]

You are welcome.

The way that formula works is it basically says to sum every cell where if you divide the row number by 11, the remainder is 3.

 

[Brown]

I tried it and after looking at it i tried to change it bc i told you a couple of wrong numbers, it is every 12 and the final cell is 711.
here is what i did and it is not working, i am sure i messed up the formula, sorry

=SUMPRODUCT(--(P3:P711),--(MOD(ROW(P3:P711),12)=3))

 

[Joe4]

That would sum rows P3, P15, P27, P39, P51, ...
Is that what you want?

 

[Brown]

thank you for the help, and sorry i am making this more difiicult

yes the cells are p3, p15, p27, p39, p51 etc.. through p711

 

[Joe4]

thank you for the help, and sorry i am making this more difiicult

yes the cells are p3, p15, p27, p39, p51 etc.. through p711

The formula I gave you will do that.

Can you test it out on a small example and see if it works?
If it does not, please let me know what your expected value is and what you are getting?