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

How do I subtotal specific / random rows from a spreadsheet? 1
Additonal info into newly created Subtotal row 1
unprotect subtotals 1
Calculating subtotals 22
Insert Properties 1
Eliminating particular numbers from a column help! 1
Updating subtotals 2
subtotal nesting errors new this month 4

Top