Totals from list by last date

[ExcelRoy]

Hi,

I have a list dating back from august last year, nearly 6000 entries since then

I have the following setup in my list

date in Q17
Engineer ID (Number) in R17
Engineer Name in S17
Job Number in T17
Job Code in U17
Hours in V17

Starting in K17 down I have every engineer ID and would like a total of hours listed for the last entry in the list in M17 down

this way I would have a list for every engineer and his last hours that he has booked

Many thanks

 

[Mike LH]

Hi,

Try this in M17, drag down.

LOOKUP(2,1/($E$17:$E$10000=K17),$H$17:$H$10000)

 

[ExcelRoy]

Hi Mike,

I think this shows all hours from start of list

I was only looking for hours on the last day of the entry (ie today only)

Thanks