View Single Post
 
Old 07-16-2015, 12:40 AM
hillbilly hillbilly is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jul 2015
Posts: 3
hillbilly is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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
Reply With Quote