Adding selected entries in columns in Excel

[hillbilly]

I have a spreadsheet to give me certain measurements in a village.



However the stages built are not consecutive numbers.

I want to add like this 138 + 139+141 to 151. but not include 140

Also other similar calculations leaving out some numbers. Like 55 -64 but not 61 & 62 Am a novice and cant find answers with Google

A description of a sum required would be good

Thanks

[macropod]

Where are these numbers - on a worksheet, perhaps? If so, where on the worksheet?

[hillbilly]

Originally Posted by macropod

Where are these numbers - on a worksheet, perhaps? If so, where on the worksheet?

Yes column B in numerical order going down.

However the place was built about 7 at time and I have to do a cleaning maintenance schedule for the stages. So stage 1 is 1-10. 2 is 11-25

3 is 61-62, 65-76.

4 is 55-60 and 63 & 64.

ETC. all rest are a bit like that. What I want to do is get a subtotal of B,C,D of 55-60 plus B,C,D of 63 & 64 as a subtotal

Not for consecutive numbers.

So a sum that looks like this =Sum (B55:60 + B63:64) or however it should be as I dont quite understand how to do it

So that it will give the measurements of those numbers only Spreadsheet looks like this

Sum to be in E 64

1 A,......B,.....C,......D,... E
Name.. 35... 10..... 46.... Subtotal column
2
All the way to 151

[macropod]

This would be easier if you attached an actual workbook. You do that via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

That said, your formula might give you what you want if you change it from:
=Sum (B61:62 + B65:76)
to:
=Sum(B61:B62,B65:B76)

[hillbilly]

Originally Posted by macropod

This would be easier if you attached an actual workbook. You do that via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

That said, your formula might give you what you want if you change it from:
=Sum (B61:62 + B65:76)
to:
=Sum(B61:B62,B65:B76)

I should have expressed it as =SUM(B61: D62, B65: D76) My error but it works now happily

Thank you that works perfectly You have been a great help.