# Excel - COUNT Function Problem - Expert Solution

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

Need to count a Specific text for specific name in a range
Solved by V. B. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 29/11/2017 - 04:09
Welcome to excel got it pro
Excelchat Expert 29/11/2017 - 04:09
User 29/11/2017 - 04:09
Hi
User 29/11/2017 - 04:09
Should I give the example?
Excelchat Expert 29/11/2017 - 04:10
sure. I need example.
User 29/11/2017 - 04:11
Now, I need to calculate, How many case Aman resolved
Excelchat Expert 29/11/2017 - 04:11
okay.
Excelchat Expert 29/11/2017 - 04:11
User 29/11/2017 - 04:11
sure
User 29/11/2017 - 04:12
Is it free service?
Excelchat Expert 29/11/2017 - 04:13
ah, first session is free. You have to buy credit for subsequent sessions.
User 29/11/2017 - 04:13
ok
User 29/11/2017 - 04:14
So first session has 14 minutes remaining
Excelchat Expert 29/11/2017 - 04:15
yes, and option for an extend of further 20 mins if the question isn't resolved. But we won't need that much time. :)
User 29/11/2017 - 04:15
ok
User 29/11/2017 - 04:15
great
Excelchat Expert 29/11/2017 - 04:17
=countifs(B:B,"=Aman",C:C,"Resolved") now this will give you result for How many Aman has resolved.
Excelchat Expert 29/11/2017 - 04:17
We need to tweak it a little bit to get result for everybody else.
User 29/11/2017 - 04:18
ThaWhy B:B?
Excelchat Expert 29/11/2017 - 04:19
first it search column B and counts Aman in it. then search C for resolved. that's why B:B and C:C. B:B means entire column B.
Excelchat Expert 29/11/2017 - 04:19
does it make sense?
User 29/11/2017 - 04:20
Right. Can I try on my sheet
Excelchat Expert 29/11/2017 - 04:20
User 29/11/2017 - 04:23
It is working
User 29/11/2017 - 04:23
Thank you so much
Excelchat Expert 29/11/2017 - 04:23
my pleasure
User 29/11/2017 - 04:23
I shows my credit is 16
User 29/11/2017 - 04:24
Can I use next time or I have to buy now?
Excelchat Expert 29/11/2017 - 04:24
if after closing the session you still have 16 remaining credits then you can get a session otherwise you would have to buy new credits.
Excelchat Expert 29/11/2017 - 04:25
Pricing should be available in the dashboard or in our homepage
Excelchat Expert 29/11/2017 - 04:25
anything else you wanna know?
User 29/11/2017 - 04:26
Thank you so much Expert
Excelchat Expert 29/11/2017 - 04:26
Excelchat Expert 29/11/2017 - 04:26
I would like to get feedback on my service.
Excelchat Expert 29/11/2017 - 04:26
Please rate me once you click on the "end session" button.
Excelchat Expert 29/11/2017 - 04:27
Have a great day! and don't forget to visit us if you fetch any kind of problem with excel.
Excelchat Expert 29/11/2017 - 04:27
:)

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.