adding a code to calculate how much time is lost

[Guest]

At work I am building a downtime sheet. The codes we are using in one colum
is SC for sawchange, R for Rocks, N for nails, M for Mecanical, E for
Electical and F for flow of production. On the column next to the code
column we fill in how much downtime we lost for the day. How can I keep
track of how much down time was for each code? I just can't figure out how to
seperant the time for the differnent codes? Thank-you for all who can help

 

[Guest]

hi,
I think the =sumif formula would be your best bet.
since you are seperating the codes, you would need a sumif for each code.
you could put the sumif formulas in a special "summary" column. you could
then sum the sumif's.
if your codes were in column a and your downtimes were in column b then

=sumif(A1:A100,"M",B1:B100) 'M for macanical

look up sumif in help for more info.

Regards
FSt1

 

[Guest]

FSt1,
Thank-you FSt1, I have spent a week on this solution and you solved it.
Many Thanks

 

[Roger Govier]

Hi

Just to add to the solution posted, you can use a cell reference in
place of the "M" in the formula.
You could create a list of your downtime codes, maybe on a second sheet
in cells A1:F1, by entering SC, R, N etc.
Then in A2 enter
=SUMIF(Sheet1!$A$1:$A$100,A1,Sheet1!$B$1:$B$100)
copy this formula across though cells B2:F2 and you will have a table of
your downtimes by reason.