Function to Sum every other cell 50 times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)))

dronad said:
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
Click to expand...
50 occurances of the logical extention to that.
There could be lots of ways to do something like this ... presumably ...
Click to expand...
and its probably already been done.
 
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
 
Back
Top