Domenic wrote:
Hi Aladin!

I do like your formula. I see you use the CELL function instead of ROW,
as I have. I certainly find it looks better and plan to steal...excuse
me...adopt it. :) But I have two questions...

1) Other than the way it looks, is there an advantage in using the CELL
function instead of ROW?

ROW() always returns an array, not a scalar. Hence the choice.


2) Why do you include '+0' when there doesn't seem a need for coercion?


I devised this formula many moons ago to capture multiple situations in
which the 'every Nth' questions arise (see SUMEVERY.XLS, I believe, by
Pearson). One set is whether one wants the formula to operate starting
with the topmost cell or the first Nth cell.

+0 means: start with the topmost cell (not coercion) and +1 start with
the first Nth.

In article ,
Aladin Akyurek wrote:


Try...

=SUMPRODUCT(--(MOD(ROW(T412:T428)-CELL("Row",T412)+0,8)=0),T412:T428)

if summing must start with the first cell of the range.

=SUMPRODUCT(--(MOD(ROW(T412:T428)-CELL("Row",T412)+1,8)=0),T412:T428)

if summing must start with the first occurrence of the Nth (8th).