On Fri, 11 Mar 2005 23:31:01 -0800, "Xandlyn"
wrote:

Posted before but I think I have it slightly figured out. I tried a Pivot
Table but didn't work the way I wanted it too. What I am trying to do is
total up the amount of an item by month and also name.

For example:
Colum A: Colum B: Colum C:
Dates: Units Sold Seller:
1/5/05 8 Josh
1/6/05 10 Josh
1/15/05 7 Rick
2/8/05 1 Josh
2/20/05 13 Rick
3/5/05 25 Rick

So far what I have come up with is
=SUMPRODUCT((C1:C10="Josh")*(A1:A10="January")*(B 1:B10))

I need to know how to get excel to look at my Dates mm/day/year and put them
all in a month catagory so it will sum up the totals for January. How do I
get excel to recognize my dates as a full month? Can I add something into
that equation? Because that equation works if I just have the Date as a
month name...but I don't want to do it like that. Please Help!


Is this the result you want:


Sum of Units Sold Seller:
Dates: Josh Rick Grand Total
Jan 18 7 25
Feb 1 13 14
Mar 25 25
Grand Total 19 45 64

I got by setting up a simple Pivot Table. I dragged dates to the rows; seller
to the columns, and Units Sold to the data area. I then right-clicked on the
dates column in the pivot table; selected Group and by Months.




--ron