sum by unique store id

[bluepenink]

Hello

I need to calculate:
1) # of stores with extra request, based on week of May30, 2011

I used this formula to calculate, # of extra request
=SUMPRODUCT(--('G.S - Report'!$L$8:$L$65536>=$D$10),--('G.S - Report'!$L$8:$L$65536<=$D$10+6),--('G.S - Report'!$J$8:$J$65536=$K17))

where D10 = 30-May-2011

however, NOW,

i need to be able to do it by unique store # as the stores might have multiple entries.

the store # are located on range ='G.S - Report'!H8:$H$65536

obviously the range is not that huge, but for the sake of being consistent with the formula....pls help!

 

[Robert Mika]

Hi jw,
Look at this example:

http://www.mrexcel.com/forum/showthread.php?p=2816547#post2816547

And try this formula:

=COUNT(1/FREQUENCY(IF($L$8:$L$65536>=$D$10,IF($L$8:$L$65536<=$D$10+6,MATCH($J$8:$J$65536&$H$8:$H$65536,$J$8:$J$65536&$H$8:$H$65536,0))),ROW($B$1:$B$65536)-ROW(AA2)+1))