Time by Name Drop Down List

[Zimmy242]

I figured out the SUMIF function, but I am struggling with the drop down list of names on this. I want L7 to be the names of the workers.

[azumi]

maybe like this, im using formula for helper column:

=IFERROR(INDEX($B$3:$B$100,AGGREGATE(15,6,IF(FREQUENCY(IFERROR(MATCH(IF($B$3:$B$100<>"",$B$3:$B$100),$B$3:$B$100,0),""),ROW($B$3:$B$100)-ROW($B$3)+1),ROW($B$3:$B$100)-ROW($B$3)+1),ROWS($A$1:A1))),"")

then to for data validation:

=OFFSET($R$2,0,0,COUNTIF($R$2:$R$100,"?*"),1)

is that you wanted?

[Zimmy242]

I think that's close, but the numbers aren't adding up correctly. I changed the format to h:mm:ss and the numbers are still wrong.

[raptor_k7]

You will not get the desired in M7 using SUMIF formula because G3, G16, G18, G20 and G25 are empty.

Attached is the file for your reference. I hope this is helpful.

PS: You have to manually enter the correct range in G3, G16, G18, G20 and G25 formulas.

[FlameRetired]

Zimmy please upload another workbook sample in your next post this time with the sums you expect manually typed in. Perhaps someone here can back engineer a solution.

By-the-way similarly to raptor I used this for the data validation list (without the SORT function).

Please Login or Register  to view this content.

Then this in M7

Please Login or Register  to view this content.