Good Evening,
I have used this formula to find the unique items in one of my spread sheets within the same work book.

=SUM(IF(FREQUENCY(IF(Rawdata!$AB$2:$AB$51000<>"",M ATCH(Rawdata!$AB$2:$AB$51000,Rawdata!$AB$2:$AB$510 00&"",0)),ROW(Rawdata!$AB$2:$AB$51000)-ROW(Rawdata!$AB$2)+1),1))

I however can not figure out that I need that criteria to also match cell A6 on my company worksheet and the date range of 01/01/2015 to 01/31/2015, which is located in a data sheet and that range is
Rawdata!$j$2:$j$51000

I am trying to get this to all read in one cell so I will capture all the unique items in my SUM, plus those items that match A6, and fall within that date range.

Thank you so much for your help.