Sum

obrijo

New Member
Joined
Jan 16, 2013
Messages
19
I would like to sum a number of rows in a column ...say K1,K7,K13 etc

Thanks in advance

John
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Sorry I wasn't very clear, just very frustrated. I've got a spreadsheet. In cell "E2" I want to insert a formula to sum Starting "I9", "I15", "I21" all the way to I 324. So the range is "I9:I324" and I want to sum every 6th row including I9.

Thanks

John
 
Upvote 0
That can be done, but it's bit complicated and inefficient to sum every x rows...

Is there anything else that might be used logically to choose which cells to sum?
A common text string in an adjacent column?
So we can use SUMIF like
=SUMIF(H:H,"SomeString",I:I)
That would sum cells in column I if the corresponding cell in column H = "SomeString"
 
Upvote 0
This will do what you ask, but I'm still interested in finding a more efficient way with some other logic..

=SUMPRODUCT(--(MOD(ROW(I9:I324)-3,6)=0),I9:I324)
 
Upvote 0
This will do what you ask, but I'm still interested in finding a more efficient way with some other logic..

=SUMPRODUCT(--(MOD(ROW(I9:I324)-3,6)=0),I9:I324)

This works fine. Thank you kindly. Would the OFFSET function be more efficient?


Many Thanks

John
 
Upvote 0
You're welcome.

I'm not sure offset would be able to accomplish the goal, so I hadn't considered it's efficiency.
 
Upvote 0
Anyways thanks again. This works fine & I also now understand the remainder & repeat in the formula.

John
 
Upvote 0

Forum statistics

Threads
1,223,958
Messages
6,175,629
Members
452,661
Latest member
Nonhle

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