Summing values incolumns from row cell L7...
 

Is it possible to Sum every 5th cell in a range of cells (i.e.
L7+L12+L17+L23....in a range of L1: L45) without entering every cell
manually?
From cell L7 and every 5th cell until cell L45.

Is this possible, if so, HOW???

Thanks

Summing values incolumns from row cell L7...
 

Have a look at http://www.cpearson.com/excel/excelF.htm, the section on
'summing every nth value'
--
Hope this helps,
MarkN


"Jay" wrote:

Is it possible to Sum every 5th cell in a range of cells (i.e.
L7+L12+L17+L23....in a range of L1: L45) without entering every cell
manually?
From cell L7 and every 5th cell until cell L45.

Is this possible, if so, HOW???

Thanks

Summing values incolumns from row cell L7...
 

=SUM(IF(MOD(ROW(L7:L45),5)=2,L7:L45))

ctrl+shift+enter (not just enter)

"Jay" wrote:

Is it possible to Sum every 5th cell in a range of cells (i.e.
L7+L12+L17+L23....in a range of L1: L45) without entering every cell
manually?
From cell L7 and every 5th cell until cell L45.

Is this possible, if so, HOW???

Thanks

Summing values incolumns from row cell L7...
 

Nodoby:

Thanks, that worked just great. Now, I need to get rid of zero's (0.00) if
there are no values in the column. How would that be done?

Thanks, again! Looking forward to your reply!



"Nobody" wrote:

=SUM(IF(MOD(ROW(L7:L45),5)=2,L7:L45))

ctrl+shift+enter (not just enter)

"Jay" wrote:

Is it possible to Sum every 5th cell in a range of cells (i.e.
L7+L12+L17+L23....in a range of L1: L45) without entering every cell
manually?
From cell L7 and every 5th cell until cell L45.

Is this possible, if so, HOW???

Thanks

Summing values incolumns from row cell L7...
 

i believe you can just add ," " before the last bracket of each cell.
for example, if your formula ended with *L47) you would change it to
*L47," ")

There may be an easier way, but that way works for me.

-------------------------

"Jay" wrote:

Nodoby:

Thanks, that worked just great. Now, I need to get rid of zero's (0.00) if
there are no values in the column. How would that be done?

Thanks, again! Looking forward to your reply!



"Nobody" wrote:

=SUM(IF(MOD(ROW(L7:L45),5)=2,L7:L45))

ctrl+shift+enter (not just enter)

"Jay" wrote:

Is it possible to Sum every 5th cell in a range of cells (i.e.
L7+L12+L17+L23....in a range of L1: L45) without entering every cell
manually?
From cell L7 and every 5th cell until cell L45.

Is this possible, if so, HOW???

Thanks