Subtotal Tool

C

Cal

Hello
I have a question about using the Subtotal tool.
I have a list of products that clients buy
Sometimes clients own this product numerous times
So I want to be able to subtotal the amount of items they own i
particular. This is fairly simple & I know how to do this
My question is, is there a way to use both the average function
the sum at the same time

For example

http://www.jungleduck.com/pictures/ExcelImage.jp

I want to total the amount of Tide they own, but I want to know th
average price they paid for it. I can only figure out how to get th
subtotal tool to either average the price paid OR total the amount
Is there anyway to do what I want? Or is there a way to easily
quickly do it using something other than the subtotal feature

Thank you guys
 
F

Franz

Hello,
I have a question about using the Subtotal tool.
I have a list of products that clients buy.
Sometimes clients own this product numerous times.
So I want to be able to subtotal the amount of items they own in
particular. This is fairly simple & I know how to do this.
My question is, is there a way to use both the average function &
the sum at the same time.

For example:

http://www.jungleduck.com/pictures/ExcelImage.jpg


I want to total the amount of Tide they own, but I want to know the
average price they paid for it. I can only figure out how to get the
subtotal tool to either average the price paid OR total the amount.
Is there anyway to do what I want? Or is there a way to easily &
quickly do it using something other than the subtotal feature?
Click to expand...

You can do easily with subtotal instruments:
add your first subtotal, say amount, then run again Subtotal Instruments and
in the dialog box uncheck the checkbox "Replace existing subtotals" and add
the other subtotal, say average.


--
Hoping to be helpful...

Regards

Franz
 
C

Cal

Thank you, that worked

I am wondering now if there is a way to get all the data to show o
one line

It says now

Amount.....Item.....Avg

................Tide........$4.7
150...........Tide...............

But I would love it if I could get it to displa

[b:8a1030c508]Amount.....Item.....Avg.[/b:8a1030c508

150...........Tide......$4.7

Is this possible
 
F

Franz

Thank you, that worked.

I am wondering now if there is a way to get all the data to show on
one line?

It says now:

Amount.....Item.....Avg.

...............Tide........$4.75
150...........Tide................

But I would love it if I could get it to display

[b:8a1030c508]Amount.....Item.....Avg.[/b:8a1030c508]

150...........Tide......$4.75


Is this possible?
Click to expand...


Maybe you can try with a Pivot Table...

--
Hoping to be helpful...

Regards

Franz
 
Top