countif bad count

Hello All,  Im attempting to count personnel in two different columns and would like any duplicate for given date to be counted once. Im currently using =COUNTIF(A2:A32,"Joe") for each column and h...