Forum Discussion

AZADDADGAR's avatar
AZADDADGAR
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's avatar
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's avatar
    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's avatar
      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's avatar
        Detlef_Lewin
        Silver Contributor
        Mar 13, 2023

        AZADDADGAR 

        =SUM(--(VSTACK(A2:A32;C2:C32)="Joe"))

         

Resources