Forum Discussion
Solved
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 ...
For such sample
in D4 is
=IF( COUNTIFS($B$4:$B4, $B4, $C$4:$C4,$C4) = 1, "Supplier " & $C4, "" )and drag it down.
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.
For such sample
in D4 is
=IF( COUNTIFS($B$4:$B4, $B4, $C$4:$C4,$C4) = 1, "Supplier " & $C4, "" )and drag it down.
- Thank you so much for your help. This is what I needed.
