Subtotals

  • Thread starter Thread starter Manos
  • Start date Start date
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.
 
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
 
Back
Top