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