Allocate a number to specific text

[D4gl15h]

Hi there
i am trying to create a downtime monitor for work, working on a production line we have to log any stops and the reason why we stopped.
So far i have come up with a monitor that logs how many stops in total, total time stopped and who was responsible counting the amount of stops an individual has caused.

What i would like to add to it now is a calculation of how much an individual is responsible for the total time stopped if that makes sense?
the problem i am having is linking times to individuals on a repetitive basis, so the list could have for instance

Jamie .25
Jamie .35
Carl .10
Chris .15
Jamie .28

So my monitor would count three stops for Jamie one for Carl and 1 for Chris. i would like it to total up Jamie's overall time also, is this possible ?
So it would look like jamie - 3 - .88

hope that makes sense

thanks in advance.

 

[AlanY]

Re: How to allocate a number to specific text

check if this work for you

Excel 2012
	A	B	C	D	E	F
1	Jamie	0.25		Jamie	0.88	3
2	Jamie	0.35
3	Carl	0.1
4	Chris	0.15
5	Jamie	0.28
Sheet4

Cell Formulas
Range	Formula
E1	=SUMIF(A:A,D1,B:B)
F1	=COUNTIF(A:A,D1)

 

[D4gl15h]

Re: How to allocate a number to specific text

Hi thanks for reply, i didn't really explain that very well lol
is there any way of adding up the top concern from a person to highlight exactly how much downtime they have caused? i will try and write a diagram below.


[TABLE="width: 960"]
<colgroup><col width="64" span="15" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 256, colspan: 4"]RESPONSIBILITY[/TD]
[TD="class: xl66, width: 384, colspan: 6"]REASON FOR STOP[/TD]
[TD="class: xl69, width: 128, colspan: 2"]DURATION[/TD]
[TD="class: xl66, width: 192, colspan: 3"]TOP CONCERNS[/TD]
[/TR]
[TR]
[TD="class: xl71, colspan: 4"]A.MURRAY[/TD]
[TD="class: xl71, colspan: 6"]PART SHORTAGE[/TD]
[TD="class: xl76, colspan: 2"]0.48[/TD]
[TD="class: xl71, colspan: 2"] [/TD]
[TD="class: xl80"] [/TD]
[/TR]
[TR]
[TD="class: xl74, colspan: 4"]A.MURRAY[/TD]
[TD="class: xl74, colspan: 6"]OVER RUN[/TD]
[TD="class: xl78, colspan: 2"]0.25[/TD]
[TD="class: xl74, colspan: 2"] [/TD]
[TD="class: xl81"] [/TD]
[/TR]
[TR]
[TD="class: xl74, colspan: 4"]B.THOMPSON[/TD]
[TD="class: xl74, colspan: 6"]QUALITY STOP[/TD]
[TD="class: xl78, colspan: 2"]0.24[/TD]
[TD="class: xl74, colspan: 2"] [/TD]
[TD="class: xl81"] [/TD]
[/TR]
[TR]
[TD="class: xl74, colspan: 4"]C.BELL[/TD]
[TD="class: xl74, colspan: 6"]OVER RUN[/TD]
[TD="class: xl78, colspan: 2"]0.36[/TD]
[TD="class: xl74, colspan: 2"] [/TD]
[TD="class: xl81"] [/TD]
[/TR]
[TR]
[TD="class: xl74, colspan: 4"]A.MURRAY[/TD]
[TD="class: xl74, colspan: 6"]OVER RUN[/TD]
[TD="class: xl78, colspan: 2"]0.24[/TD]
[TD="class: xl74, colspan: 2"] [/TD]
[TD="class: xl81"] [/TD]
[/TR]
[TR]
[TD="class: xl74, colspan: 4"]C.ELLIOT[/TD]
[TD="class: xl74, colspan: 6"]PART SHORTAGE[/TD]
[TD="class: xl78, colspan: 2"]0.26[/TD]
[TD="class: xl74, colspan: 2"] [/TD]
[TD="class: xl81"] [/TD]
[/TR]
[TR]
[TD="class: xl74, colspan: 4"]C.KANE[/TD]
[TD="class: xl74, colspan: 6"]QUALITY STOP[/TD]
[TD="class: xl78, colspan: 2"]0.12[/TD]
[TD="class: xl74, colspan: 2"] [/TD]
[TD="class: xl81"] [/TD]
[/TR]
[TR]
[TD="class: xl74, colspan: 4"]C.MCALISTER[/TD]
[TD="class: xl74, colspan: 6"]OVER RUN[/TD]
[TD="class: xl78, colspan: 2"]0.11[/TD]
[TD="class: xl74, colspan: 2"] [/TD]
[TD="class: xl81"] [/TD]
[/TR]
[TR]
[TD="class: xl74, colspan: 4"] [/TD]
[TD="class: xl74, colspan: 6"] [/TD]
[TD="class: xl78, colspan: 2"] [/TD]
[TD="class: xl74, colspan: 2"] [/TD]
[TD="class: xl81"] [/TD]
[/TR]
[TR]
[TD="class: xl74, colspan: 4"] [/TD]
[TD="class: xl74, colspan: 6"] [/TD]
[TD="class: xl78, colspan: 2"] [/TD]
[TD="class: xl74, colspan: 2"] [/TD]
[TD="class: xl81"]


[/TD]
[/TR]
</tbody>[/TABLE]
so if that was my layout in excel can i get it to automatically count the individuals times and place them in the top concern section? so based on that table it would be a.murray with the highest amount of time then c.bell as he has the second highest time?

hope that makes sense. thanks again

regards