# Excel - COUNT Function Problem - Expert Solution

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

i have a list of text and i want to categorize them and count them
Solved by B. Q. in 19 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 24/01/2018 - 09:59
hello
Excelchat Expert 24/01/2018 - 09:59
Welcome to excel got it pro
Excelchat Expert 24/01/2018 - 10:00
Please tell me details
User 24/01/2018 - 10:00
so as you can see i have a list
User 24/01/2018 - 10:00
i might need to use a pivot table but what i am trying to do is create a chart that has each different value with a count of how many are in the list
Excelchat Expert 24/01/2018 - 10:00
Yes, I can see now.
Excelchat Expert 24/01/2018 - 10:02
Sorry, you want a chart or just count?
User 24/01/2018 - 10:02
a chart
User 24/01/2018 - 10:03
basically i want what i just did but for it to automatically count
Excelchat Expert 24/01/2018 - 10:03
Sorry, this was listed as a formula problem, hence I have claimed it. I don't know charts much.
User 24/01/2018 - 10:03
ooook
Excelchat Expert 24/01/2018 - 10:03
I can help with a formula though.
User 24/01/2018 - 10:04
could you give me a formula that would do this:
User 24/01/2018 - 10:04
if it says fx2day then count it
Excelchat Expert 24/01/2018 - 10:04
yes it can.
User 24/01/2018 - 10:04
awesome
User 24/01/2018 - 10:04
could you enter it in h4
User 24/01/2018 - 10:04
Excelchat Expert 24/01/2018 - 10:05
=countif(A:A,F4) this is the formula
User 24/01/2018 - 10:05
thank you very much
Excelchat Expert 24/01/2018 - 10:05
My pleasure.
Excelchat Expert 24/01/2018 - 10:05
anything else?
User 24/01/2018 - 10:05
is there anyway you could transfer me to someone who could help me with a chart/pivot table?
Excelchat Expert 24/01/2018 - 10:06
I can help with pivot table too.
User 24/01/2018 - 10:06
ok thank you
Excelchat Expert 24/01/2018 - 10:06
Gimme a few minutes please.
Excelchat Expert 24/01/2018 - 10:06
Have you deleted the data?
User 24/01/2018 - 10:07
I added more data
User 24/01/2018 - 10:07
so i want the first column in the pivot table to be in different rows the values in column E
Excelchat Expert 24/01/2018 - 10:08
Do you have column Headers?
User 24/01/2018 - 10:08
i can add that
Excelchat Expert 24/01/2018 - 10:08
Please do, and what about column H?
User 24/01/2018 - 10:08
so i want to categorize everything by method of shipment
User 24/01/2018 - 10:08
i meant to delete H
User 24/01/2018 - 10:08
i deleted it now
Excelchat Expert 24/01/2018 - 10:09
Thanks, a few minutes please.
User 24/01/2018 - 10:09
so basically i want the first column in the pivot to be the each of the different values of column E
User 24/01/2018 - 10:09
and then for example all of the UPS2DAIR's H columns to be added up
User 24/01/2018 - 10:09
if that makes sense
Excelchat Expert 24/01/2018 - 10:10
Yes it does.
Excelchat Expert 24/01/2018 - 10:11
Just made a pivot table on "Pivot Table 1" tab.
Excelchat Expert 24/01/2018 - 10:13
Have you seen it?
User 24/01/2018 - 10:13
yes i am looking at it
Excelchat Expert 24/01/2018 - 10:13
Okay, let me know.
User 24/01/2018 - 10:13
would the pivot table also be able to add up the values in column h
Excelchat Expert 24/01/2018 - 10:14
yeap it would.
User 24/01/2018 - 10:14
that correspond with column a of the pivot table
User 24/01/2018 - 10:15
thank you
User 24/01/2018 - 10:15
can you keep the count also
User 24/01/2018 - 10:15
Excelchat Expert 24/01/2018 - 10:16
There you go, it is there now.
User 24/01/2018 - 10:18
perfect
Excelchat Expert 24/01/2018 - 10:18
Please close the session now and also leave a feedback for me. :)
Excelchat Expert 24/01/2018 - 10:18
A 5 star would mean a lot.
User 24/01/2018 - 10:18
thank you
User 24/01/2018 - 10:18
you guys have the best website lol
Excelchat Expert 24/01/2018 - 10:19
Thanks for trying out excel got it pro. Have a great 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

Trusted by people who work at