Is it possible to Sum every 5th cell in a range of cells (i.e.
L8+L13+L18+L24....in a range of L1: L45) without entering every cell
manually?

From cell L8 and every 5th cell until cell L45.

Is this possible, if so, HOW???

Thanks


=SUM(IF(MOD(ROW(M8:M48),5)=2,M8:M48,""))

Your formula should work. All you have to commit ctrl+shift+enter (not just
enter)

"Jay" wrote:

Is it possible to Sum every 5th cell in a range of cells (i.e.
L8+L13+L18+L24....in a range of L1: L45) without entering every cell
manually?

From cell L8 and every 5th cell until cell L45.

Is this possible, if so, HOW???

Thanks


=SUM(IF(MOD(ROW(M8:M48),5)=2,M8:M48,""))

=SUM(IF(MOD(ROW(M8:M48)-1,5)=2,M8:M48,""))

Entered as array formula (Ctrl+Shift+Enter)

"Nobody" wrote:

Your formula should work. All you have to commit ctrl+shift+enter (not just
enter)

"Jay" wrote:

Is it possible to Sum every 5th cell in a range of cells (i.e.
L8+L13+L18+L24....in a range of L1: L45) without entering every cell
manually?

From cell L8 and every 5th cell until cell L45.

Is this possible, if so, HOW???

Thanks


=SUM(IF(MOD(ROW(M8:M48),5)=2,M8:M48,""))

This thread is a kick!

In the first place, if one wants to add up some values in L8,L13,L18...
why is everyone considering a formula that operates on Column M?

Secondly, every fifth cell starting with Row 8 does not include Row 24,
as the OP's original posting suggested.

Thirdly, with the numbers 1 through 45 in M1:M45, the sum of
M8,M13,M18,M23,M28,M33,M38,M43 is 204, whereas the OP's originally
posted formula, array entered, returns 189; but then, of course, Nobody
said it should work. :-)

Toppers's formula works.

Alan Beban

Toppers wrote:
=SUM(IF(MOD(ROW(M8:M48)-1,5)=2,M8:M48,""))

Entered as array formula (Ctrl+Shift+Enter)

"Nobody" wrote:

Your formula should work. All you have to commit ctrl+shift+enter (not just
enter)

"Jay" wrote:

Is it possible to Sum every 5th cell in a range of cells (i.e.
L8+L13+L18+L24....in a range of L1: L45) without entering every cell
manually?

From cell L8 and every 5th cell until cell L45.

Is this possible, if so, HOW???

Thanks


=SUM(IF(MOD(ROW(M8:M48),5)=2,M8:M48,""))

=SUMPRODUCT(--(MOD(ROW(L8:L45)-ROW(L8),5)=0),L8:L45)

Jay wrote:
Is it possible to Sum every 5th cell in a range of cells (i.e.
L8+L13+L18+L24....in a range of L1: L45) without entering every cell
manually?

From cell L8 and every 5th cell until cell L45.

Is this possible, if so, HOW???

Thanks


=SUM(IF(MOD(ROW(M8:M48),5)=2,M8:M48,""))