Forum Discussion

Copper Contributor

Mar 06, 2023

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...

excel

Formulas and Functions

AZADDADGAR

Copper Contributor

Mar 13, 2023

Detlef_Lewin Thank you for the reply. Is there a place to enter the specific person I'm looking to count? Im not sure what is being counted with this formula. I'd like to know how many rows (in columns A & C) "Joe " is being counted. Thanks for the help.

Detlef_Lewin

Silver Contributor

Mar 13, 2023

AZADDADGAR

If you are counting "Joe" then you are not counting unique values.

So, what's it gonna be?

AZADDADGAR
Copper Contributor
Mar 13, 2023
Detlef_Lewin
I’d like to count “Joe” NOT unique. I’m sorry if that was confusing. Thanks again.
- Detlef_Lewin
  Silver Contributor
  Mar 13, 2023
  AZADDADGAR
  =SUM(--(VSTACK(A2:A32;C2:C32)="Joe"))
  - AZADDADGAR
    Copper Contributor
    Mar 14, 2023
    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.