All solutions SUM Expert Solution – Excel SUM Problems

Excel - SUM Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

how do you calculate percentile rank in excel when the question mean is known for 10 companies. Example the Mean is 3.58 from the sum of the 10 companies Mean divided by 10. The lowest Mean of the 10 organizations is 2.85 and the highest Mean is 4.22 Our goal is to be able to show the percentile rank of the 10 companies for their mean.
Solved by X. W. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 07/08/2018 - 02:00
Hi
Excelchat Expert 07/08/2018 - 02:00
Welcome to Got it Pro
Excelchat Expert 07/08/2018 - 02:01
Are you there?
User 07/08/2018 - 02:01
yes
Excelchat Expert 07/08/2018 - 02:02
Do you have any excel sheet
User 07/08/2018 - 02:02
yes
Excelchat Expert 07/08/2018 - 02:02
Can you please send me
User 07/08/2018 - 02:04
Well it isn't that easy due to propriety issues with clients. If you give me 5 minutes I could work with the file
Excelchat Expert 07/08/2018 - 02:04
please create sample file
Excelchat Expert 07/08/2018 - 02:05
Once you completed please let me know'
Excelchat Expert 07/08/2018 - 02:16
ARe you there?
Excelchat Expert 07/08/2018 - 02:16
Our timing is going to expire
Excelchat Expert 07/08/2018 - 02:16
please extend the time
Excelchat Expert 07/08/2018 - 02:16
Are you there?
User 07/08/2018 - 02:17
Yes, can you see what I just typed or do I need to email it to you. If so, what is your email.
Excelchat Expert 07/08/2018 - 02:18
No need.
Excelchat Expert 07/08/2018 - 02:18
I will work on it
Excelchat Expert 07/08/2018 - 02:22
I am working on it
Excelchat Expert 07/08/2018 - 02:27
Is it fine
User 07/08/2018 - 02:29
Appears so, but did you insert a formula to get what you have showing here and is there a way I can keep this.
Excelchat Expert 07/08/2018 - 02:29
yes.I inserted formula
Excelchat Expert 07/08/2018 - 02:30
Shall I download this excel and send it to you
User 07/08/2018 - 02:31
that would be great debdwyer@hsdmetrics.com or it appears I may be able to save.
Excelchat Expert 07/08/2018 - 02:31
FYI
[Uploaded an Excel file]
Excelchat Expert 07/08/2018 - 02:31
Its always available anyway you can download this sheet

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc