Count IF/Sum IF

[Amber]

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.

 

[Bob Phillips]

Sounds like a job for a pivot table to me

See http://www.contextures.com/xlPivot01.html
and http://www.peltiertech.com/Excel/Pivots/pivottables.htm


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Amber]

I am looking to do an expression because I would like the information to be
within the table. Is it not possible to do a function for this?

 

[Bernard Liengme]

Bob is correct in suggesting a pivot table but if you are not ready to learn
ow to use them, try SUMPRODUCT. A good place to start is
http://www.ozgrid.com/excel-add-ins/sumproduct.htm but you can Goggle 'Excel
sumproduct' to get lots of other sites with hints.
best wishes

 

[Amber]

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.