JKJ95

=SUMPRODUCT((MOD(ROW(A1:A500),10)=0)*A1:A500)

HTH,
Bernie
MS Excel MVP


"JKJ95" wrote in message
...
Is it possible to Sum every 10th cell in a range of cells (i.e.
a10+a20+a30....in a range of a1:a500) without entering every cell
manually?
Thanks.