Sum and skipping cells

[art]

Hello all:

Is it possible to sum the cells by starting from A1 and add A10 then A20,
and so on every tenth cell. How do I write the formula for it?

 

[Mike H]

Try this

=A1+SUM(IF(MOD(ROW($A$1:$A$100),10)=0,$A$1:$A$100,0))

it's an array so commit with CTRL+Shift+Enter not just enter. If you do it
correctly Excel will put curly brackets {} around it.

Mike

 

[Ashish Mathur]

Hi,

you may array enter (Ctrl+Shift+Enter) the following formula

SUM(IF((MOD(ROW(range),10)=1),range))

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com