Excel - COUNT Function Problem - Expert Solution

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

I am trying to find a formula to count the number of times a month and year occurs
Solved by G. H. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 15/09/2017 - 03:01
Welcome to Excel Got-it pro
Excelchat Expert 15/09/2017 - 03:01
User 15/09/2017 - 03:01
I am trying to find a fuction to count the number of times confirm times appear in Sepetermber 2017 and August 2017
User 15/09/2017 - 03:01
using pivot table
User 15/09/2017 - 03:01
or an excel formula
Excelchat Expert 15/09/2017 - 03:01
sorry I didn't get you.
Excelchat Expert 15/09/2017 - 03:02
Can you please be more specific like what is confirm time.
User 15/09/2017 - 03:02
No worries
User 15/09/2017 - 03:02
Did you see what I add in column A
User 15/09/2017 - 03:02
Do you see how in each row, there is a date
User 15/09/2017 - 03:02
I am trying to count the number of times September 2017 pops up
User 15/09/2017 - 03:02
Without manually counting it
Excelchat Expert 15/09/2017 - 03:03
okay now I got it.
Excelchat Expert 15/09/2017 - 03:03
you want to count how many times a month have occurred right?
Excelchat Expert 15/09/2017 - 03:06
is it?
User 15/09/2017 - 03:08
hi
User 15/09/2017 - 03:08
si sirry i just got ths
User 15/09/2017 - 03:08
I am trying to do the month of the year
User 15/09/2017 - 03:08
so how many counts in september 2017
Excelchat Expert 15/09/2017 - 03:09
okay
User 15/09/2017 - 03:11
would a pivot table be the best thing to do?
Excelchat Expert 15/09/2017 - 03:11
nope, I formula
User 15/09/2017 - 03:12
So there are data for January in 2017 and 2016
User 15/09/2017 - 03:12
can you differentiate them
Excelchat Expert 15/09/2017 - 03:12
yes, gimme some time
Excelchat Expert 15/09/2017 - 03:15
so your data is in excel?
User 15/09/2017 - 03:16
yes
Excelchat Expert 15/09/2017 - 03:19
Here you go.
Excelchat Expert 15/09/2017 - 03:19
User 15/09/2017 - 03:19
i counted the sepetmber 2017 and i got 1718
Excelchat Expert 15/09/2017 - 03:20
Well this is my formula
Excelchat Expert 15/09/2017 - 03:20
=SUMPRODUCT(1*(MONTH(\$A\$2:\$A\$30000)=MONTH(C9)))
User 15/09/2017 - 03:20
there are data for 2016 too
User 15/09/2017 - 03:20
maybe you combined the two years
User 15/09/2017 - 03:20
is there someone else that can help us
Excelchat Expert 15/09/2017 - 03:21
no need, I'm enough.
Excelchat Expert 15/09/2017 - 03:21
So, now I'm gonna modify the formula to exclude dates from 2016,15
User 15/09/2017 - 03:22
thx
Excelchat Expert 15/09/2017 - 03:22
or you want to count months from those years too?
User 15/09/2017 - 03:22
i do for all of the months/year
User 15/09/2017 - 03:24
I got it
User 15/09/2017 - 03:24
I used pivot table
User 15/09/2017 - 03:24
If you can find the formula, that would be great too
User 15/09/2017 - 03:24
I can wait
Excelchat Expert 15/09/2017 - 03:24
okay
Excelchat Expert 15/09/2017 - 03:32
User 15/09/2017 - 03:33
yes that is what i got thanks
Excelchat Expert 15/09/2017 - 03:33
Thanks for the patience
User 15/09/2017 - 03:33
thank you for helping me
Excelchat Expert 15/09/2017 - 03:33
My pleasure
Excelchat Expert 15/09/2017 - 03:33
Have a great day
User 15/09/2017 - 03:34
wait
User 15/09/2017 - 03:34
oh nvm
User 15/09/2017 - 03:35
hm its not working for me
Excelchat Expert 15/09/2017 - 03:36
what is the problem?
User 15/09/2017 - 03:36
the count gives me 0
Excelchat Expert 15/09/2017 - 03:36
for which month?
User 15/09/2017 - 03:36
for all of them
Excelchat Expert 15/09/2017 - 03:36
=SUMPRODUCT(1*(MONTH(\$A\$2:\$A\$30000)=MONTH(D2))*(YEAR(\$A\$2:\$A\$30000)=\$C\$2))
Excelchat Expert 15/09/2017 - 03:37
apply this for 2017
Excelchat Expert 15/09/2017 - 03:37
as you can see, the result is there
User 15/09/2017 - 03:38
i see, i do not know why it is not working for me
User 15/09/2017 - 03:38
ill figure it out thnks
Excelchat Expert 15/09/2017 - 03:38
where are you applying the formula?
Excelchat Expert 15/09/2017 - 03:40
Okay the session time is up. thanks for choosing excel got it pro.

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.