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
https://docs.google.com/spreadsheets/d/12eqEr2I-Pgd-Ehe8kJztUmr4wKsDGJZ_nG34krWqLiM/edit#gid=0
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
for your time & assistance
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.