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.

Count IF/Sum IF
 

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" wrote in message
...
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.

Count IF/Sum IF
 

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?

"Bob Phillips" wrote:

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" wrote in message
...
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.

Count IF/Sum IF
 

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
--
www.stfx.ca/people/bliengme


"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.

Count IF/Sum IF
 

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.