Maybe if I use the frequency function?

[ExcelMBA]

I have a data table that registers daily sales and there are several sales per day. I need to create an array function that groups sales into single days. </SPAN></SPAN>
E.g.</SPAN></SPAN>
Date Product Sales</SPAN></SPAN>
1/1/13 X 50</SPAN></SPAN>
1/1/13 Y 100</SPAN></SPAN>
1/2/13 X 10</SPAN></SPAN>
1/2/13 X 20</SPAN></SPAN>
1/3/13 Y 50</SPAN></SPAN>
1/3/13 Z 200</SPAN></SPAN>
...

Result array must show:</SPAN></SPAN>

Date Sales</SPAN></SPAN>
1/1/13 150</SPAN></SPAN>
1/2/13 30</SPAN></SPAN>
1/3/13 250</SPAN></SPAN>
...

I could manage if this is achieved: create an array formula that changes this:</SPAN></SPAN>
</SPAN></SPAN>
{50,100,10,20,50,200...}</SPAN> </SPAN>

And summarizes data to this:</SPAN></SPAN>

{150,30,250...}</SPAN> </SPAN>

Hope someone can help. Thank you </SPAN></SPAN>

 

[ExcelMBA]

That`s amazing!

It Works great, although I`m still scratching my head on how it actually Works! Thank you very much Cyrilbrd. It`s not 100% exactly what I need but I`m going to start working from this. You`ve done so much. Much more than I would`ve ever imagined. You`re awesome pal! Thanks.</SPAN></SPAN>

 

[cyrilbrd]

That`s amazing!

It Works great, although I`m still scratching my head on how it actually Works! Thank you very much Cyrilbrd. It`s not 100% exactly what I need but I`m going to start working from this. You`ve done so much. Much more than I would`ve ever imagined. You`re awesome pal! Thanks.

Most welcome.
Glad it somehow worked for you.
And thanks for the kind words.