# Excel - COUNT Function Problem - Expert Solution

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

Hi I've Col D ( Tech/Non-Tech) & Col J ( contains month name ). Now I want to see the total count of Technical or Non-Technical against the particular month. Can you pls assist with that?
Solved by V. F. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 14/09/2017 - 09:10
No
Excelchat Expert 14/09/2017 - 09:10
Hello there, I understand that you would like to see the summary of your data based on Column D and J (month), right?
User 14/09/2017 - 09:10
exactly
Excelchat Expert 14/09/2017 - 09:10
Will you be able to upload your data using the document preview to the right or at least a part of it so I can analyze it and work on it?
Excelchat Expert 14/09/2017 - 09:13
Hello, to do what you need to do, you simply have to use a Pivot Table.
Excelchat Expert 14/09/2017 - 09:14
I have created a test data in the document preview.
Excelchat Expert 14/09/2017 - 09:15
I have also created the Pivot Table 1 tab where the Pivot table is created to show the summary of your data based on those 2 columns.
User 14/09/2017 - 09:15
ok
User 14/09/2017 - 09:15
but if I want to do with formula then?
Excelchat Expert 14/09/2017 - 09:15
I'll create the formula for you in Sheet2
User 14/09/2017 - 09:16
I am unable to upload the file
User 14/09/2017 - 09:17
I've to just set the formula in summary to see the total no. of Technical & Non-technical categories against the perticular month ex. January
Excelchat Expert 14/09/2017 - 09:18
If you'll look at Sheet2, I created the SUMIFS() formula that sums the data you need depending on the king of TECH or Month.
User 14/09/2017 - 09:19
Can you pls paste the formula here .. as i can't see the preview
Excelchat Expert 14/09/2017 - 09:19
Without your data, this is the best I can do for you and you will have to adjust the formula yourself since you are the only one who has analyzed it.
Excelchat Expert 14/09/2017 - 09:19
=sumifs(Sheet1!\$K:\$K,Sheet1!\$D:\$D,"Tech",Sheet1!\$J:\$J,B1)
Excelchat Expert 14/09/2017 - 09:19
Where Sheet1!\$K:\$K is the column you want to summarized
Excelchat Expert 14/09/2017 - 09:19
and B1 is the Month you want.
User 14/09/2017 - 09:20
ok
User 14/09/2017 - 09:20
Got it
Excelchat Expert 14/09/2017 - 09:20
For Non-Tech:
Excelchat Expert 14/09/2017 - 09:20
=sumifs(Sheet1!\$K:\$K,Sheet1!\$D:\$D,"Non-Tech",Sheet1!\$J:\$J,E1)
Excelchat Expert 14/09/2017 - 09:20
Where E1 is the Month as well.
Excelchat Expert 14/09/2017 - 09:20
User 14/09/2017 - 09:20
Tok
Excelchat Expert 14/09/2017 - 09:20
Try if you can access that link.
User 14/09/2017 - 09:20
Sure
Excelchat Expert 14/09/2017 - 09:20
That's the test data I work on.
User 14/09/2017 - 09:20
Thanks a ton !
Excelchat Expert 14/09/2017 - 09:21
Entering Explanation Phase
User 14/09/2017 - 09:21
Excelchat Expert 14/09/2017 - 09:21
What I used is the SUMIFS() formula and also a pivot table to summarized your data.
Excelchat Expert 14/09/2017 - 09:21
Entering Discussion Phase
Excelchat Expert 14/09/2017 - 09:21
Do you have any questions regarding the solution provided?
User 14/09/2017 - 09:21
Thanks again
Excelchat Expert 14/09/2017 - 09:21
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 14/09/2017 - 09:21
Please do not forget to click the End Session otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.
User 14/09/2017 - 09:21
for now .. no queries further
User 14/09/2017 - 09:21
yes.. sure
Excelchat Expert 14/09/2017 - 09:21
Alright, bye for now. Thank you for contacting GotIt Pro!
Excelchat Expert 14/09/2017 - 09:22
You may click the End session button once you are ready.
User 14/09/2017 - 09:22
Bye... Thanks to you :)

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.