Excel - SUM Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.