Running total for each row

[markmac234]

Hi
I am trying very hard to get to grips with Excel and for the most part, I'm doing OK. However, I have a problem with a table I'm trying to create. Basically, I want a list of serial numbers for components in the first column, a second column which will be used as an input column for hours and the third column will be the total for each row. Each week I have to input the hours used for each serial numbered component, which will then give me a running total per row for each item. Also, is there a way of clearing the data entered in the second column ready for the next data input a week later? Please send any ideas or some other way of approaching this.
Thanks,
Mac

 

[d0wnt0wn]

well the first part for the running total is quite easy..... lets say you have 25 things in your list but you may be getting that list up to 50 eventually.... the list that you want your running total in is in the "C" column... click in cell c51 and typ =sum(c1:c50) and press enter... thats your running total.... it does not sound like your spreadsheet is too intricate..... if you want to clear the column and start again highlight the selection you want cleared with your mouse and right click and select clear contents