Hi!
Try this:
=SUMPRODUCT(--(ISNUMBER(A1:A6)),--(MONTH(A1:A6)=1),--
(C1:C6="Josh"),B1:B6)
OR, use cells to hold your conditions:
D1 = 1 (month number for JAN)
E1 = Josh
=SUMPRODUCT(--(ISNUMBER(A1:A6)),--(MONTH(A1:A6)=D1),--
(C1:C6=E1),B1:B6)
Biff
-----Original Message-----
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!
.
|