Thank you both....I can do pivot tables but I will try the sum product.
Hopefully that fits what I am trying to accomplish.

Thanks again.

"Amber" wrote:

I have a document where I want to know how many of a product that I seel each
day.

I have this to show how many are sold as a total
=SUMIF('Total Sales'!E:E,'Premiums Sent'!A3,'Total Sales'!G:G)

I also have a column that I have dates and I want to be able to break this
down and say how many of a1 are sold on each day.