How do I insert a function on a subtotal row?

  • Thread starter Thread starter Tim Ellis
  • Start date Start date
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!
 
Tim,

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