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?
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
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)
 
Upvote 0
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.
 
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top