Try Pivot Table ..

Some quick steps to ease you in?

Assuming the sample data given is in Sheet1,

Click anywhere within the data

Click Data Pivot Table Report Next Next

In step 3 of the wizard:
drag Seller and drop within ROW area
drag Dates and drop within COLUMN area
drag Units Sold and drop within DATA area
(it'll appear as Sum of Units Sold)

Click Finish

The Pivot Table (PT) will appear
in a new sheet to the left of Sheet1

In the PT,

Right-click on Dates Group and Outline Group

In the Group dialog,
you'll see that By "Months" has been pre-selected

Click OK

Voila, you'll get what you want .. :

Sum of Units Sold__Dates:
Seller:___________Jan Feb Mar Grand Total
Josh_____________18_1________19
Rick______________7_13__25____45
Grand Total_______25__14__25____64

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Xandlyn" wrote in message
...
How do I 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 I am trying to set up a chart where January Gives the totals for Josh
and
Rick in seperate cells and etc. for each month.