Sumif(D:D,"Bob",C:C) in cell F3 and Sumif(D:D,"Joe",C:C)