# Get percentage shared between 2 numbers

##### Board Regular
I feel really stupid for asking this question but i don't know where to find out how to do it.

I have a number is columns A, B and C

Say in column A i have 1000, column B is 30000 and column C is 10000.

In column D and E i want to know (in number format) what percentage of column A goes in these columns. I would expect column D to have 666.66 and column E to have 333.33.

I know it's a simple sum but i really can't remember the math to find out these numbers.

Can anyone please remind me how to do this?

### Excel Facts

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Are you sure it's not 750 and 250?
I'm not sure what logic you are using to hit 2/3rds and 1/3rds out of the above numbers.

I suspect you're looking for something like:
D2: =\$A2*(B2/SUM(\$B2:\$C2))
copied right into E2: =\$A2*(C2/SUM(\$B2:\$C2))

Though this would give you 750 (1000 * 3/4) and 250 (1000 * 1/4)

Replies
2
Views
375
Replies
16
Views
493
Replies
1
Views
176
Replies
5
Views
265
Replies
0
Views
205

1,211,710
Messages
6,103,454
Members
447,866
Latest member
bowers261

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

### Which adblocker are you using?

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

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