Sum or subtotal every 10th cell

[bgonen]

I'm trying to create a formula for subtotal for a range A:CC adding A1 first then A11 then A21 etc,,,

Thanks
bg

 

[c_m_s_jr]

This will work in range A and sum every 10th cell.

{=SUM(IF(MOD(ROW(A1:A21)-1,10)=0,A1:A21))}

Confirm with control+shift+enter to get the {} as this is an array formula

 

[mikerickson]

=sumproduct(a1:a10000,--(mod(row(a1:a10000), 10) = 1))

 

[Jonmo1]

Try

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

 

[bgonen]

Thank you all
I tried the formulas (but horizontally) and I got inaccurate sum numbers (probably I'm doing something wrong)


=SUMPRODUCT(P58:CCC58,--(MOD(COLUMN(P58:CCC58), 15) = 1))

I decided to use the Sum If formula instead and I got the correct sum amount.

Thanks again
bg

 

[Jonmo1]

Try
=SUMPRODUCT(P58:CCC58,--(MOD(COLUMN(P58:CCC58)-COLUMN(P58), 15) = 0))