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

"JKJ95" wrote:

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.