Quote:
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