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")*(B1 :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!