HELP! Totals by two variables?
 

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.

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.

Personally, I don't rate Pivot Tables. If you want a non-Pivot table
solution, try this

ON another sheet
In B1-M1, put the dates 1/1/05, 2/1/05, etc
In A2:An, put the Seller's names

In B2:
=SUMPRODUCT(--(Month(Sheet1!A1:A1000)=Month(B$1)),--(Year(Sheet1!A1:A1000)=Y
ear(B$1)),--(Sheet1!C1:C1000=$A2),Sheet1!B1:B1000)

and copy across and down

--

HTH

RP
(remove nothere from the email address if mailing direct)


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

"Bob Phillips" wrote
Personally, I don't rate Pivot Tables. ..
Left room for a non-pivot table solution to breeze by <bg
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"Max" wrote in message
...
"Bob Phillips" wrote
Personally, I don't rate Pivot Tables. ..
Left room for a non-pivot table solution to breeze by <bg

And I blew <ebg

"Bob Phillips" wrote
Personally, I don't rate Pivot Tables. ..

Now that's something we have in common!

Biff

-----Original Message-----


"Max" wrote in message
...
"Bob Phillips" wrote
Personally, I don't rate Pivot Tables. ..
Left room for a non-pivot table solution to breeze by
<bg

And I blew <ebg


.

"Biff" wrote in message
...
"Bob Phillips" wrote
Personally, I don't rate Pivot Tables. ..

Now that's something we have in common!

We have a third like mind, but I won't 'out' him <g