Sum arithmetic progression cells ?

[hpbaxxter]

• Hi!
  My question is : Is it possible to create a formula that would give the sum of cells that are in arithmetic progression in excel?
  
  Example:
  Let's first choose 4 cells that are in arithmetic progression, B14 , B20 , B26 and B32 for instance(the common difference here is 6). So what I want to do is: I want to type a formula in another cell, lets suppose C5, that will automatically give me the sum of the values of B14,B20,B26 and B32. I am aware that I can just type on C5 =B14+B20+B26+B32 but and if I wanted the sum of 90 cells??Wouldn't it be too much work to type all the cells? Does Anyone know a formula for it?
  
  thanks! :]​
  
  
  
  

 

[hpbaxxter]

Thank you VBA Geek

 

[Alowolodu]

Hi!
My question is : Is it possible to create a formula that would give the sum of cells that are in arithmetic progression in excel?

Example:
Let's first choose 4 cells that are in arithmetic progression, B14 , B20 , B26 and B32 for instance(the common difference here is 6). So what I want to do is: I want to type a formula in another cell, lets suppose C5, that will automatically give me the sum of the values of B14,B20,B26 and B32. I am aware that I can just type on C5 =B14+B20+B26+B32 but and if I wanted the sum of 90 cells??Wouldn't it be too much work to type all the cells? Does Anyone know a formula for it?

Besides I have also tried the sum product formula but if not giving me the correct answer.

thanks!