excel report figure % on grand total column

**Mike Hughes** · 10-17-2012, 07:49 AM

I need some help with a formula on a report.

The report has a 2 grand total at the bottom of the report, current owed & current paid.

The grand total sum looks like
=Sum([CURRENT OWED])
=Sum([CURRENT PAID])

what formula would I use to figure the % of PAID to OWED

would it be something like?

=SUM(=Sum([CURRENT PAID])/=Sum([CURRENT OWED]))

Thanks Mike

**TMS** · 10-17-2012, 07:56 AM

Try:

=Sum([CURRENT PAID])/Sum([CURRENT OWED])

Regards, TMS

**Mike Hughes** · 10-17-2012, 08:03 AM

Thanks so much!
Mike

**TMS** · 10-17-2012, 08:51 AM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save