Counting Duplicate Item Totals based on Date

[bhoppy06]

I am trying to calculate the total count for duplicate items based on the date. In the first table you can see that I am able to get a total duplicate item count with the COUNTIF statement (item abc total count = 3, item def total count = 3) How do I make it so it only counts duplicate items that are on the same date?? For example, Table 2 is how it should appear. I need the count for item abc to total 2 for 6/6/2020 and 1 for 6/8/2020.



View attachment 15336

 

[bhoppy06]

Sorry Table 1 didn't save to the post. But right now the COUNTIF formula is totaling the count for ABC and DEF as 3. When the count should really total what appears on the table that I posted.

 

[Fluff]

Hi & welcome to MrExcel.
You will need to use COUNTIFS rather than COUNTIF, for that, as it can handle multiple criteria.