Hello,

Hopefully i can have a few questions answered all at once here.

1) Is the sum function within excel limited to approximately 30 cells
?

e.g. when I sum the cells =sum(c14,c22,c30,c38,c46……… it
seems to stop after I get to about 30 cells.

2) Is there a difference in summing them like that or like this
=sum(c14+c22+c30+……….

3) is there a quicker way to sum cells when they are each a constant
number apart, like the above scenario where each cell number I want to
sum increases by 8 each time ?

I have about 52 cells to sum (one for each week of the year) and I am
thinking the only other way I can do it is to sum 10 at a time, then
do a final sum on those 6 x values but I would like it to be a bit
neater.

I thought there might have been an option somewhere like

=sum($C14+($n+8)+$C398) where the starting cell is c14 and the end
cell is c398 and it sums every multiple cell of 8 in between.

(I just made that up of course, but it's sort of the formula i am
trying to achieve).


Regards and many thanks in advance,

Angela