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.
