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