Question description:
This user has given permission to use the problem statement for this
blog.
I cant share my file, but ive got a data pool of 503, of the pool i need to know how many have value $1,000,000 in a specific column.
Solved by A. U. in 10 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
05/02/2018 - 04:44
Hello, I understand that you need help in counting the number of records that have a value equal to $1,000,000, right?
User
05/02/2018 - 04:45
correct
Excelchat Expert
05/02/2018 - 04:45
Alright, we can help you with this.
Excelchat Expert
05/02/2018 - 04:45
Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question.
User
05/02/2018 - 04:45
ideally, i need to pull that specific column into a pie chart too
Excelchat Expert
05/02/2018 - 04:45
Since you can't share the file, can you tell me which column do you need to check?
User
05/02/2018 - 04:45
P
Excelchat Expert
05/02/2018 - 04:45
Up to what rows is your data?
User
05/02/2018 - 04:46
535
Excelchat Expert
05/02/2018 - 04:46
Thank you.
Excelchat Expert
05/02/2018 - 04:46
What's the sheet name?
User
05/02/2018 - 04:46
does that matter?
Excelchat Expert
05/02/2018 - 04:46
Yes so I can write an accurate formula for you. One that you won't have to edit.
Excelchat Expert
05/02/2018 - 04:47
But I can also provide a general formula.
User
05/02/2018 - 04:47
the sheet name is Master SOV
Excelchat Expert
05/02/2018 - 04:47
You'll just have to update it.
Excelchat Expert
05/02/2018 - 04:47
Is the condition only equal to $1,000,000? Or do you need to count the ones that are greater than $1,000,000 too?
Excelchat Expert
05/02/2018 - 04:48
If it's just equal to then you can use this:
Excelchat Expert
05/02/2018 - 04:48
=COUNTIFS('Master SOV'!P:P,1000000)
User
05/02/2018 - 04:48
in column P there are 3 value options: $1,000,000, $100,000 or 0. basically i need to know how many times each value appears
Excelchat Expert
05/02/2018 - 04:50
Okay.
Excelchat Expert
05/02/2018 - 04:50
Here's the formula for counting 0
Excelchat Expert
05/02/2018 - 04:50
=COUNTIFS('Master SOV'!P:P,0)
Excelchat Expert
05/02/2018 - 04:50
Here's for 100000
Excelchat Expert
05/02/2018 - 04:50
=COUNTIFS('Master SOV'!P:P,100000)
Excelchat Expert
05/02/2018 - 04:50
Finally, here's for the million.
Excelchat Expert
05/02/2018 - 04:50
=COUNTIFS('Master SOV'!P:P,1000000)
User
05/02/2018 - 04:50
its saying theres an error
Excelchat Expert
05/02/2018 - 04:51
May I know what the error is?
User
05/02/2018 - 04:51
wait! if i take out the sheet name the error goes away
User
05/02/2018 - 04:51
=COUNTIFS(P:P,1000000) worked
Excelchat Expert
05/02/2018 - 04:51
Ah, the sheet name may have been incorrect then but it should be fine if you are using the formula in the same sheet.
Excelchat Expert
05/02/2018 - 04:52
You only need the sheet name if you are using the formula in another sheet.
User
05/02/2018 - 04:52
oh man! you are wonderful
Excelchat Expert
05/02/2018 - 04:52
You are welcome. :)
Excelchat Expert
05/02/2018 - 04:53
Would there be anything else that I can help you with regards to the original question?
User
05/02/2018 - 04:53
no, now that i have the values i can make the chart i need. im so grateful! thank you!
Excelchat Expert
05/02/2018 - 04:53
Alright, if you have no other questions regarding the original concern, I'd appreciate a 5-star rating if you think I deserve it. :)
Excelchat Expert
05/02/2018 - 04:53
I'll be giving you high ratings as well so the other experts will know that you are a good client and should be taken care of. :)
Excelchat Expert
05/02/2018 - 04:53
Please do not forget to click the End Session button otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.
User
05/02/2018 - 04:54
sure,ill rate you... is there a link to that?
Excelchat Expert
05/02/2018 - 04:54
Once you click the End session button, you'll be presented the survey.
Excelchat Expert
05/02/2018 - 04:54
I'd appreciate it. :)
User
05/02/2018 - 04:54
perfect! ill end now and rate you. thanks again! enjoy your day
Excelchat Expert
05/02/2018 - 04:55
Thank you for contacting Got It Pro. Have an awesome 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.