i have a drop list for selection of staff in an area, but can i then do another droplist and use the sumif function to sum up the total time depending on the value of the list.

ie if i selected name 1 it would search all of the sheet to see if name 1 was there and then add the times. see attached for an idea of what im talking about.


cheers in advance


wayne