Count IF/Sum IF
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.
|