ExcelBanter - sum by skiping one cell

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sum by skiping one cell (https://www.excelbanter.com/excel-discussion-misc-queries/4498-sum-skiping-one-cell.html)

Faisal Yameen

sum by skiping one cell

I want to sum only even cells from A1 : A1000
I used =a2+a4+a6+a8+€¦€¦€¦€¦..+a1000
Used this formula n cell b1
But now I want to solve this problem by some short formula
Help me thank you

Aladin Akyurek

See your post at worksheet.functions.

Faisal Yameen wrote:
I want to sum only even cells from A1 : A1000
I used =a2+a4+a6+a8+€¦€¦€¦€¦..+a1000
Used this formula n cell b1
But now I want to solve this problem by some short formula
Help me thank you

Bob Phillips

or even here

--
HTH

Bob Phillips

"Aladin Akyurek" wrote in message
...
See your post at worksheet.functions.

Faisal Yameen wrote:
I want to sum only even cells from A1 : A1000
I used =a2+a4+a6+a8+......+a1000
Used this formula n cell b1
But now I want to solve this problem by some short formula
Help me thank you

All times are GMT +1. The time now is 06:07 AM.