**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need a formula which can sum up several cells and tell me its percentage from a total in another cell

Solved by S. Q. in 15 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
13/08/2018 - 07:05

Hello

Excelchat Expert
13/08/2018 - 07:05

Welcome

User
13/08/2018 - 07:05

hi there!

Excelchat Expert
13/08/2018 - 07:05

Hi

User
13/08/2018 - 07:06

I have multiple cells vertically alligned, and I also have another one which shows me a total, I need to select a range from those cells and receive %

Excelchat Expert
13/08/2018 - 07:06

Would you be able to show me an example of what you need?

User
13/08/2018 - 07:11

I need a formula that gets me each percentage per platform

User
13/08/2018 - 07:12

thanks

Excelchat Expert
13/08/2018 - 07:12

For example, how much is desktop of total spent?

User
13/08/2018 - 07:12

exactly

Excelchat Expert
13/08/2018 - 07:12

Thank you, I need a few minutes.

Excelchat Expert
13/08/2018 - 07:14

This is the formula. =SUMIF($A$2:$A$16,"Desktop",$B$2:$B$16)/$H$2

Excelchat Expert
13/08/2018 - 07:14

Here $H$2 is the overall total.

User
13/08/2018 - 07:15

what if my total is in another sheet

Excelchat Expert
13/08/2018 - 07:15

SUMIF($A$2:$A$16,"Desktop",$B$2:$B$16) will give us the total for Desktop.

Excelchat Expert
13/08/2018 - 07:16

Let's assume total is in sheet2 cell A1, then you write sheet2!$A$1 in the place of $H$2

User
13/08/2018 - 07:16

great

Excelchat Expert
13/08/2018 - 07:16

Does that make sense?

Excelchat Expert
13/08/2018 - 07:16

I'm glad to hear that.

User
13/08/2018 - 07:16

sure mate! cheers

Excelchat Expert
13/08/2018 - 07:17

Thanks, please consider rating me 5 star if you think I was helpful.

User
13/08/2018 - 07:17

can I test it offline? will I use this all if I click on END SESSION?

User
13/08/2018 - 07:17

sorry virgin

Excelchat Expert
13/08/2018 - 07:17

Sure, you can test it.

User
13/08/2018 - 07:17

lose / not use

User
13/08/2018 - 07:17

awesome

Excelchat Expert
13/08/2018 - 07:18

You can also download the file by clicking on the File menu. File->Download As->Excel document.

User
13/08/2018 - 07:19

superb

User
13/08/2018 - 07:19

closing now! that was a huge help!!!

Excelchat Expert
13/08/2018 - 07:19

Thanks for the appreciation. Have a great day!

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*