I need help counting unique position numbers within a given date range. The dates are listed in B2 and B3 and will change based on the time period the report will be run. So far, I've tried the following:
SUMPRODUCT(IF((A:A<=B3)*(A:A>=B2), 1/COUNTIFS(A:A, "<="&B3, A:A, ">="&B2, E:E, E:E), 0))
But I keep getting zero. How do i count unque postion numbers based on a given date range. I need Counts in B5, B6, B7, and B8. We will add more data each week.
Bookmarks