Excel - COUNT Function Problem - Expert Solution

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

I have something that is charged by units. I have a total unit count (ie 100), but the dollar value is different for each unit length (ie 0 to 25, 25 to 50 etc) how do I create these different ranges from the original total?
Solved by M. C. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 25/03/2018 - 05:45
Welcome, Thanks for choosing Got It Pro-Excel
User 25/03/2018 - 05:48
how do i put a value in column E?
User 25/03/2018 - 05:50
Using the values for D1 and D2/
Excelchat Expert 25/03/2018 - 05:50
Thank you for such a good question.
Excelchat Expert 25/03/2018 - 05:51
Are we suppose to create different ranges from the original total?
User 25/03/2018 - 05:54
I know the final totals (D1 and D2) I know the ranges A5 to C7 and A11 to C17.
User 25/03/2018 - 05:55
I need to know how to calculate a value for D5 to D7 and D11 to D17
Excelchat Expert 25/03/2018 - 05:55
Alright, please give a moment to solve your problem. Thank you!
User 25/03/2018 - 06:01
are you still there?
Excelchat Expert 25/03/2018 - 06:01
Yeah, figuring out the problem. Is there something which you can add on the question?
User 25/03/2018 - 06:04
It is a diamond driiling program. First the drill casing to bedrock total = total casing is "D2" it is charged at 3 different rates. Then they start coring bedrock then it is charged at various rates.
User 25/03/2018 - 06:05
In the end I know my totals. Is it possible to calculate the amount of meters in each range from the total?
Excelchat Expert 25/03/2018 - 06:07
Yes it is possible.
User 25/03/2018 - 06:08
please explain how I may do it.
User 25/03/2018 - 06:08
Thank you
Excelchat Expert 25/03/2018 - 06:09
One way of solving this is solving the "What-if-Analysis"
Excelchat Expert 25/03/2018 - 06:10
We can collaborate online, but in order to work on a What-if-Analysis on this, then I have to work on this locally and send you a file.
User 25/03/2018 - 06:11
ok thanks, do you know how long this may take?
Excelchat Expert 25/03/2018 - 06:13
Yeah, before the session ends we will be in a position to provide you with the solution.
Excelchat Expert 25/03/2018 - 06:13
If analysis needs one to identify the conditions which are in the problem.
User 25/03/2018 - 06:14
one other little wrinkle. if they drill 18 meters of casing for example then under the coring the first from would be 18 not 0.
Excelchat Expert 25/03/2018 - 06:14
Okay. Kindly provide all such like conditions so that they are factored in Analysis.
Excelchat Expert 25/03/2018 - 06:15
This will help us to provide you with the most accurate solution. Thank you.
User 25/03/2018 - 06:15
that should be all the conditions.
User 25/03/2018 - 06:16
ie if they drill 18 m of casing and the final hole depth was 333m
User 25/03/2018 - 06:18
I would be charged 15m @ "H5" 3m at "H6", 132m at "H11" 150m at "H12" and 33m at "H13"
Excelchat Expert 25/03/2018 - 06:18
Good. In your Desktop application, What-If-Analysis is located in the Data tab, under the Data Tools Group. Click on the Seek Goal option.
User 25/03/2018 - 06:19
User 25/03/2018 - 06:26
now what?
Excelchat Expert 25/03/2018 - 06:28
The conditions are not all. The values that are being returned are not equivalent with those in D1 and D2 i.e. for Final Depth and Casing.
Excelchat Expert 25/03/2018 - 06:29
Is it possible I can have the whole problem statement?
Excelchat Expert 25/03/2018 - 06:31
I apologize, I am unable to finish your problem since the conditions provided are insufficient.
Excelchat Expert 25/03/2018 - 06:32
Kindly provide the whole problem statement so that we are in the position to examine all the conditions. Thank you.
User 25/03/2018 - 06:32
I know my final depth of casing. I know the dollar value per depth range. I need to figure out how much meterage is in each range.
User 25/03/2018 - 06:34
Then I know my total depth of coreing which is the total - casing and again I I know the dollar value per depth range. I need to figure out how much meterage is in each range.
User 25/03/2018 - 06:35
Then I will be able to times the meterage by the dollar value and and get my total costs per rang. I can then ads these up and I will have my total costs.
User 25/03/2018 - 06:39
no luck?
Excelchat Expert 25/03/2018 - 06:40
Since the information you have added was not there initially, the session will end automatically before we factor it in the solution. I kindly request you to re-post the question with all the information and we will be in a position to help you.
Excelchat Expert 25/03/2018 - 06:41
We apologize for that. Your credits will not be deducted. Thank you for understanding.

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
The Allstate Corporation
United Parcel Service
Dell Inc