Please Help me! Grand Total Formulas!!!!

jessi

New Member
Joined
Jul 11, 2012
Messages
1
Hi

I need Help I have a table created already and i need to figure out the the grand total and then change it to a percentage.


C D E F

Cost Unit Number of Units Total Cost %Grand Total
5 $2.99 25 $74.75 ?????
6 $0.99 40 $39.60 ??????
7
8

I have the answer to the %Grand Total in percentage already as 14% for the first problem and 8% for the second one in my workbook for class but what is the formula to how they got to those percent numbers. PLEASE HELP ME!!!
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Mindpsyche

Well-known Member
Joined
Mar 19, 2012
Messages
760
If for the first unit $2.99 the number of units sold is 25 resulting in $ 74.75 which in turn represents 14 % of your total? Then your grand total in absolute terms is 74.75 / 14 * 100 = $ 533.92

Not sure if this is what you want.
 

njimack

Well-known Member
Joined
Jun 17, 2005
Messages
7,764
Is there more data that you haven't posted? Those percentages only make sense if the total of the table is around 500.

Excel Workbook
ABCD
1Cost UnitNumber of unitsTotal Cost% Grand Total
22.992574.7565%
30.994039.635%
Sheet2
 

Watch MrExcel Video

Forum statistics

Threads
1,123,481
Messages
5,601,918
Members
414,482
Latest member
morkar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top