Good morning
I have this formula that I want to count non duplicated items between dates. I am not sure what I am missing.
=SUM(1/COUNTIFS('Sheet2 (2)'!$H$2:$H$7,'Sheet2 (2)'!$H$2:$H$7,'Sheet2 (2)'!$N:$N,">="&A2,'Sheet2 (2)'!$N:$N,"<="&B2))
Good morning
I have this formula that I want to count non duplicated items between dates. I am not sure what I am missing.
=SUM(1/COUNTIFS('Sheet2 (2)'!$H$2:$H$7,'Sheet2 (2)'!$H$2:$H$7,'Sheet2 (2)'!$N:$N,">="&A2,'Sheet2 (2)'!$N:$N,"<="&B2))
You messedI am not sure what I am missing.and small exampleMS-Off Ver:Excel 2003
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks