Count upon some conditions

[Gildasl]

Hi,

I need to count the number of days that at least one red umbrella is sold and group them between 2 dates (every 2 weeks).
In the case below:
1 day at least some umbrella have been sold between 6/15/2011 and 6/30/2001
2 days at least some umbrella have been sold between 8/1/2011 and 8/15/2011.

Thanks,
Gildas


<table border="0" cellpadding="0" cellspacing="0" width="358"><colgroup><col style="mso-width-source:userset;mso-width-alt:5595;width:115pt" width="153"> <col style="mso-width-source:userset;mso-width-alt:7497;width:154pt" width="205"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;width:115pt" height="20" width="153">Creation date</td> <td class="xl66" style="width:154pt" width="205">Number of sales of Red umbrella</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">6/28/2011</td> <td class="xl66">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">6/28/2011</td> <td class="xl66" align="right">93</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">7/8/2011</td> <td class="xl66">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">7/21/2011</td> <td class="xl66">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">8/2/2011</td> <td class="xl66">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">8/4/2011</td> <td class="xl66" align="right">5</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">8/5/2011</td> <td class="xl66" align="right">2</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">8/5/2011</td> <td class="xl66">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">8/8/2011</td> <td class="xl66">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">8/10/2011</td> <td class="xl66">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">8/15/2011</td> <td class="xl66" align="right">120</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">8/16/2011</td> <td class="xl66">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20" align="right">8/16/2011</td> <td class="xl66">
</td> </tr> </tbody></table>

 

[Gildasl]

Big Thanks T. Valko. I own you a beer

 

[T. Valko]

Big Thanks T. Valko. I own you a beer

You're welcome. Thanks for the feedback!