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 each item has a row, so supplier A appears 5 times. 

On the same day, the 2nd purchase had 3 items: two items from supplier B and one item from supplier C.  

The total sales came from 3 different suppliers, but how do I count this using a formula in Excel? 

The total of items on day 11th is 8, each item has a row, and sales come from 3 suppliers. 

I want the result to appear in the column next to the data. 

So in C1, the result will be supplier A, and C2 to C5 returns blank.

Resources