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

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#D9E1F2]Date (Month)[/td][td=bgcolor:#D9E1F2]Dec[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#D9E1F2]Count[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

3​

[/td][td][/td][/tr]
[/table]

 

[rookst]

Thanks, but I can't in this instance .

 

[sandy666]

Pity

Have a nice day