ExcelBanter - use of sum by skiping one or more cells

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

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

- - use of sum by skiping one or more cells (https://www.excelbanter.com/excel-discussion-misc-queries/4497-use-sum-skiping-one-more-cells.html)

Faisal Yameen

use of sum by skiping one or more cells

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

2rrs

Try this:

=SUMPRODUCT((MOD(ROW(A1:A1000),2)=0)*(A1:A1000))

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 02:35 AM.