Subtotals

M

Manos

If subtotal sums 3 rows i want for every row (in a new column) the division
with the corresponding subtotal.In my worksheet i have many subtotals for
which i have to do that.
 
S

Suleman Peerzade

Hi,

For eg. you have four rows sumed so the next col should have the below
formula.
ie the value of subtotal is divided by value of the cell you want to divide
then you can copy the formula for that particular set of cells and so on.
=B9/B5
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 - Outline not displaying all nested subtotals 0
Problem with subtotal function 0
Calculating subtotals 22
Calculating subtotals 0
How do I subtotal specific / random rows from a spreadsheet? 1
Additonal info into newly created Subtotal row 1
Vlookup a subtotal 2
I need ONLY subtotals copied to a second sheet 4

Top