Forum Discussion

nessatm's avatar
nessatm
Copper Contributor
Sep 24, 2023

Excel countifs excluding a value

Hello,   I’m trying to count several different suppliers in a column based on the date.  So, for example, I have 2 purchases on the 11th of September. 1st purchase has 5 items from supplier A, and ...
Excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Sep 24, 2023

    nessatm 

    For such sample

    in D4 is

    =IF( COUNTIFS($B$4:$B4, $B4, $C$4:$C4,$C4) = 1, "Supplier " & $C4, "" )

    and drag it down.

nessatm's avatar
nessatm
Copper Contributor
Sep 24, 2023

Thanks for responding it. Column Date and Supplier are correct. Column SKU is where I need the formula, and the results should be like the screenshot. 

SergeiBaklan 

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Sep 24, 2023

    nessatm 

    For such sample

    in D4 is

    =IF( COUNTIFS($B$4:$B4, $B4, $C$4:$C4,$C4) = 1, "Supplier " & $C4, "" )

    and drag it down.

    • nessatm's avatar
      nessatm
      Copper Contributor
      Sep 30, 2023
      Thank you so much for your help. This is what I needed.

Share

Resources