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
Bookmarks