Counting data based on Month and Year only

[rookst]

Hi All,

>> Please see sample

https://www.dropbox.com/s/coe8pwb71vmgslg/Example.xlsx?dl=0

Based on the Input month (which is in date format), I'd like to get a count of sales by sales person: disregarding the day.

So, as George 8764 is listed twice, he should only be counted once, making the count for December 2018 3

Seems very simple, but I can't figure it out!

MANY THANKS!

 

[Special-K99]

George is 8765

Cant get it to work on a "working" unique formula copied from elsewhere though.

 

[rookst]

Sorry I'm not following? I've tried using Sumproduct, Countifs to no avail.

Thanks for trying

 

[sandy666]

maybe try PivotTable with DataModel to count unique names

Date (Month)	Dec
Count
3​

 

[rookst]

Thanks, but I can't in this instance .

 

[sandy666]

Pity

Have a nice day