The following formula works fine; but it takes into consideration the duplicates. How can I change it to count any repeat numbers only once?
=COUNTIFS(Assignment_3000_38,">"&0, plant_3000_38,"="&C220,posting_date_3000_38,">="&'Months & Dates'!$C$7,posting_date_3000_38,"<="&'Months & Dates'!$D$7)
Thanks
Bookmarks