Please Help me! Grand Total Formulas!!!!

[jessi]

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!!!

 

[Mindpsyche]

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]

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
	A	B	C	D
1	Cost Unit	Number of units	Total Cost	% Grand Total
2	2.99	25	74.75	65%
3	0.99	40	39.6	35%
Sheet2