ExcelBanter - Sum and skipping cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sum and skipping cells (https://www.excelbanter.com/excel-worksheet-functions/203066-sum-skipping-cells.html)

Art

Sum and skipping cells

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

Sum and skipping cells

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

"art" wrote:

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?

Ashish Mathur[_2_]

Sum and skipping cells

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

"art" wrote in message
...
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?

All times are GMT +1. The time now is 05:41 AM.