Forum Discussion
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...
Detlef_Lewin
Thanks for the formula, it works but it counts "Joe" in both columns. The employee should be counted once per row (i.e. A2=Joe, C2=Joe; count should be 1). Thanks for your continued efforts.
Thanks for the formula, it works but it counts "Joe" in both columns. The employee should be counted once per row (i.e. A2=Joe, C2=Joe; count should be 1). Thanks for your continued efforts.
