# Calculating Percentages for an Annual Report

1. ## Calculating Percentages for an Annual Report

good morning, i am trying to calculate percentages in excel, i am working on an annual report where the original report is generated for me with the proper percent. I have to remove numbers from the original and create a new percent, i am having trouble creating a new percent.i found that the percentage calculator is accurate but it takes to long with as many number as i have. below are some of the numbers so you can see what i am trying to accomplish. TIA

With the percentage calculator i use the ____ is what percent of ____?
SO in my report i have the numbers everything is based off of (below)

Total Events- 8,597
Events w RR Response- 5,209
Total Arrivals- 5,389
Total Activities- 12.878

and the percentages i am trying to find for these numbers,

Road Ranger Assisted Events BY Notifier

CCTV - 2,365
Local PD - 54
Fire - 12
EMS - 68
Local SO - 32

I need to find the percent of Notifier events, in the percentage calculator i use

Notifier is what percent of Events with Road Ranger Response
Example - 2,365 is what % of 5,209? = 45.22%

I would like to be able to input these numbers and use a formula to calculate the percentages fast than one at a time in the percentage calculator.

Thank you so much, i hope this explains what i am trying to do.

2. ## Re: Percentages

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

3. ## Re: Percentages

Changed the title

4. ## Re: Calculating Percentages for an Annual Report

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

5. ## Re: Calculating Percentages for an Annual Report

i will do that right now, thank you.

6. ## Re: Calculating Percentages for an Annual Report

I have attached an example

7. ## Re: Calculating Percentages for an Annual Report

I have also attached a photo of what the report looks like when it generates for me, before i have to recalculate after subtracting numbers.

8. ## Re: Calculating Percentages for an Annual Report

This is so basic, that I am not sure I understand exactly what the question is.

1) Since understanding the math is critical to understanding the solution, I would suggest you start here http://www.purplemath.com/modules/percntof.htm with a basic tutorial of how to solve "per cent of" problems.
2) Since "a is what per cent of b" boils down to a simple division (percent=a/b), enter that division in Excel. In your first attachment, I put =C15/\$D\$4 into a cell in row 15 and copied/filled down. One could also use C15/\$C\$32, if desired.

I am not sure what help you need in going from the report (picture) in the second attachment to the first attachment.

9. ## Re: Calculating Percentages for an Annual Report

i just needed a formula.

10. ## Re: Calculating Percentages for an Annual Report

i have to pull two separate report like in the picture of the second attachment and subtract those numbers from each other. SO i will be needing a new percentage with the new numbers.

11. ## Re: Calculating Percentages for an Annual Report

thank you that works.

There are currently 1 users browsing this thread. (0 members and 1 guests)