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

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet267​

Worksheet Formulas Cell Formula C3 =B3/B$9 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

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.