**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.*