Sum Formula Needs To Skip 1 Row

zerocoolxp

New Member
Joined
Oct 27, 2006
Messages
2
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?
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
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
#s you want added

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
Joined
Oct 27, 2006
Messages
2
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
Joined
Oct 12, 2006
Messages
44,061
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())

now your sumif would be
=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)
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,538
Members
410,547
Latest member
htran4
Top