How do I insert a function on a subtotal row?

T

Tim Ellis

I am using subtotals on two columns using the sum
function. I would like to calculate the percent between
the two subtotal fields. How do I insert a
function/formula for a cell on the same row as the
subtotal row? Thanks for any help!
 
B

Bob Phillips

Tim,

Isn't is simply
=A17/C17
where A17 and C17 have your subtotals? Format the result cell as percent.
 

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

Vlookup a subtotal 2
Can I use the subtotal function while a worksheet is protected? 0
Additonal info into newly created Subtotal row 1
Unmatched rows 0
How do I subtotal specific / random rows from a spreadsheet? 1
Getting Text data using the Data - Subtotal feature 1
Subtotal across a row 1
Macro Pause to Select range then Subtotal 0

Top