# Sum Formula Needs To Skip 1 Row

#### zerocoolxp

##### New Member
Hello everyone,

I need help with creating a formula for work. I'm trying to add the values in colum K but not all the lines. It needs to skip 1 row at a time.

This is my current formula:

=K8+K10+K12+K14+K16+K18+K20+K22

I noticed if I add a few rows between K8 and K22 they don't get added to the formula. Is there a way to automatically add the newly added rows to the formula without doing it manually?

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### Jonmo1

##### MrExcel MVP
You could add a collumn next to the collumn with the numbers you want added and use an iseven (or isodd) formula, then sumif based on results of that...

collumn a

collumn b
=iseven(row()) OR
=isodd(row())

Then your sumif formula will be based off of collumn B
=sumif(B:B,TRUE,A:A)

#### zerocoolxp

##### New Member
That looks perfect!

Although I can't add anything to the column next to it cause those columns are trying to perform the same action.

#### Jonmo1

##### MrExcel MVP
You could put that in ANY collumn - say furthes to the right in your sheet...
say that is collumn Z for example

collumn z =iseven(row())

=sumif(Z:Z,TRUE,A:A)

In fact, you could even put the iseven function on another sheet altogeter...
Say you put the iseven function on Sheet2 collumn A and the #s you want counted are on Sheet 1 Collumn A

=SUMIF(Sheet2!A:A,TRUE,Sheet1!A:A)

Replies
0
Views
77
Replies
5
Views
189
Replies
7
Views
130
Replies
3
Views
37
Replies
2
Views
127