Excel - SUM Function Problem - Expert Solution

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

I need help with getting a sum for a specific range of dates
Solved by X. W. 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 - 05:50
Welcome, Thanks for choosing Got It Pro-Excel
Excelchat Expert 29/11/2017 - 05:50
How may I help you today?
User 29/11/2017 - 05:50
hi I am trying to calculate the total number of dates between a range in google sheets
Excelchat Expert 29/11/2017 - 05:51
can you please give me an example
User 29/11/2017 - 05:52
So Row G has dates from 5/1/2014 to 11/1/2017 and I need to figure out how many times the dates for each month repeat. For example: How many people subscribed for the month of May 10
User 29/11/2017 - 05:52
2014*
Excelchat Expert 29/11/2017 - 05:52
give me one moment please
User 29/11/2017 - 05:52
thank you
Excelchat Expert 29/11/2017 - 05:58
I am working on that please be online
User 29/11/2017 - 05:59
So for example I need to look up between certain dates : 5/1/2014 and 6/1/2014 and get a sum of how many dates are in that range
Excelchat Expert 29/11/2017 - 06:00
Sure you can use countifs function for that
Excelchat Expert 29/11/2017 - 06:01
=COUNTIFS(G1:G948,">=5/1/2014",G1:G948,"<=5/31/2014")
Excelchat Expert 29/11/2017 - 06:01
I have mentioned random range G1:G948
Excelchat Expert 29/11/2017 - 06:01
you can change that as per your requirement
User 29/11/2017 - 06:02
Thank you! It works!
Excelchat Expert 29/11/2017 - 06:02
your welcome :)
Excelchat Expert 29/11/2017 - 06:02
If you have any more issues, please don’t hesitate to let us know. Have a great day!
User 29/11/2017 - 06:02
Wow! Thank you this was very helpful! You do the same
Excelchat Expert 29/11/2017 - 06:03
Thanks for choosing Got It Pro-Excel
Excelchat Expert 29/11/2017 - 06:03
bye for now
Excelchat Expert 29/11/2017 - 06:03
take care :)

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.