Function to Sum every other cell 50 times

[dronad]

Hi,

I need a function that would, say, Sum N occurances of a cell which are all the same offset away.

Something like: SUMDATASERIES(A1, C1, 50)

This takes the data in the first row, sees the pattern of A1, C1, and SUMS 50 occurances of the logical extention to that.

There could be lots of ways to do something like this ... presumably ... and its probably already been done.

Any help? TIA

 

[Aladin Akyurek]

If you mean to add every other cell in a horizontal range consisting of 50
cells, try...

=SUMPRODUCT((MOD(COLUMN($A$1:INDEX(1:1,50)-CELL("Col",$A$1)+0,2)=0)*($A$1:IN
DEX(1:1,50)))

Hi,

I need a function that would, say, Sum N occurances of a cell which are all the same offset away.

Something like: SUMDATASERIES(A1, C1, 50)

This takes the data in the first row, sees the pattern of A1, C1, and SUMS

50 occurances of the logical extention to that.

There could be lots of ways to do something like this ... presumably ...

and its probably already been done.

 

[Gerry Kuta]

Hi Aladin,
I get a "too many arguments error" when I try this formula
in one of my workbooks, it seems to highlight the 2 in
your formula. Could you please help me understand that?

TIA

 

[Alan Beban]

The formula needs another right parenthesis after the first INDEX(1:1,50)

Alan Beban