Count value in column and then sum

[hailstorm]

Hello there

I have this sales sheet made throughout the year. I'd like to identify month by month the products that had more sales not only in total, but also day by day in that month.
Which product was sold every day of the month, instead of which product had the most sell in total numbers. Example:

I want the Count column to show the product that was selling almost every day and then in the quantity column sum the sales.
Count Column needs to show the top product, the Quantity Column don't.

Thanks.

 

[jasonb75]

Have you tried a pivot table?

Rows as Months (Date) and Product, Values as Count of Quantity Sold and Sum of Quantity Sold. Sort by Count of Qauntity Sold.