Excel - COLUMN Function Problem - Expert Solution

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.

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