Total Questions
 

I currently use the autofilter on a spreadsheet to find all of the departments.
I also use a subtotal function,=subtotal(9,c2:c128), to total all of the
amounts of the department.

What I need to know how to do is divide and multiply these subtotal amounts,
so that I can get these totals when I use the autofilter, instead of manually
calculating each one.

Ex. If I have Unit Price and Total Ordered. I need to have these both
multiplied.
And if I have to find a percentage, I need to divide Unit Price by Total
Billed.

Please help.

Thank You

You want this done on a row by row basis - why not add a dummy column where
the calculation is performed.

Or if you mean you need to multiply the subtotal by a single unit price

=subtotal(9,c2:c128)*UnitPrice

You might want to look at using a pivot table.

--
Regards,
Tom Ogilvy



"Metalteck" wrote in message
...
I currently use the autofilter on a spreadsheet to find all of the
departments.
I also use a subtotal function,=subtotal(9,c2:c128), to total all of the
amounts of the department.

What I need to know how to do is divide and multiply these subtotal
amounts,
so that I can get these totals when I use the autofilter, instead of
manually
calculating each one.

Ex. If I have Unit Price and Total Ordered. I need to have these both
multiplied.
And if I have to find a percentage, I need to divide Unit Price by Total
Billed.

Please help.

Thank You

How would I create a Pivot Table to calculate all of this.

"Tom Ogilvy" wrote:

You want this done on a row by row basis - why not add a dummy column where
the calculation is performed.

Or if you mean you need to multiply the subtotal by a single unit price

=subtotal(9,c2:c128)*UnitPrice

You might want to look at using a pivot table.

--
Regards,
Tom Ogilvy



"Metalteck" wrote in message
...
I currently use the autofilter on a spreadsheet to find all of the
departments.
I also use a subtotal function,=subtotal(9,c2:c128), to total all of the
amounts of the department.

What I need to know how to do is divide and multiply these subtotal
amounts,
so that I can get these totals when I use the autofilter, instead of
manually
calculating each one.

Ex. If I have Unit Price and Total Ordered. I need to have these both
multiplied.
And if I have to find a percentage, I need to divide Unit Price by Total
Billed.

Please help.

Thank You