cross check names and associated values to give a total

Guy's

which formula achieves the following:

i have a simple table design with the dates running across the row, below each row i write the name of the person on shift. in the 3rd row i mark the time they are late for work (if any).

below that in a seperate table i have a list of my staff next to that i would like there to be a running total of their lateness.

I need a formular that will look for their names and then total any lateness that i have inserted

I have include a basic spreedsheet of what i want to achieve, the column in RED is where i wan the totals


thanks Martin

Try this for Jo, drag down for others

=SUMIF($B$2:$V$2,A10,$B$3:$V$3)

You can use SUMIF

Please Login or Register  to view this content.

Format B10:B12 as [hh]:mm