calculate % of total based on value in cell

[halloyd]

Hi there,

I have a sheet with claims. There are different claim reasons and costs.

Here is what I'm working with:

In another sheet, I have the total of $ amount and the different reasons.

Here's what that looks like:

I'm trying to find the % each contributes to the total amount.

Is there a formula for this?

Thank you!

 

[jtakw]

Hi,

Isn't is just a simple division?, or am I missing the larger part of the question?

Book1
	B	C
2	Amount	% of Claims
3	$3,532.05	51.70%
4	$1,403.80	20.55%
5	$1,161.80	17.00%
6	$734.80	10.75%
7	$0.00	0.00%
8	$0.00	0.00%
9	$6,832.45
Sheet267

Cell Formulas
Range	Formula
C3	=B3/B$9

Formula copied from C3 to C8, Format C3:C8 as percentage.

 

[halloyd]

Hi,

Isn't is just a simple division?, or am I missing the larger part of the question?

	B	C
Amount	% of Claims

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]$3,532.05[/TD]
[TD="align: right"]51.70%[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]$1,403.80[/TD]
[TD="align: right"]20.55%[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]$1,161.80[/TD]
[TD="align: right"]17.00%[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]$734.80[/TD]
[TD="align: right"]10.75%[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]0.00%[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]0.00%[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]$6,832.45[/TD]
[TD="align: right"][/TD]

</tbody>

Sheet267​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C3[/TH]
[TD="align: left"]=B3/B$9[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



Formula copied from C3 to C8, Format C3:C8 as percentage.

Well, I wish you were missing something... But I'm just dumb and thought it would be a lot more complicated. I hate math.

Thank you!!

 

[jtakw]

You're very welcome, that happens a lot, sometimes we get so wrapped up with the problem, our brains get cloudy and just need another set of eyes.