Question description:
This user has given permission to use the problem statement for this
blog.
HOW CAN I COUNT NUMBERS PER DAY FOR A MONTH AS TOTAL?
Solved by F. F. in 16 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
18/08/2018 - 01:37
Hi
Excelchat Expert
18/08/2018 - 01:37
Welcome to Got it Pro
Excelchat Expert
18/08/2018 - 01:38
Do you have any excel sheet
Excelchat Expert
18/08/2018 - 01:39
Are you there?
User
18/08/2018 - 01:39
Hello
User
18/08/2018 - 01:39
yes i am
User
18/08/2018 - 01:39
i had a question
User
18/08/2018 - 01:39
i was hoping you can help with
Excelchat Expert
18/08/2018 - 01:39
do you have any excel file or sample data?
User
18/08/2018 - 01:39
yes i do
User
18/08/2018 - 01:40
but the file is too large to send
Excelchat Expert
18/08/2018 - 01:40
Can you please create sample data and explain me your expectation... I need few clarification about your question
User
18/08/2018 - 01:41
so sheet 2
Excelchat Expert
18/08/2018 - 01:41
yes
User
18/08/2018 - 01:41
i want to count all column L for Jan
User
18/08/2018 - 01:42
then for feb
User
18/08/2018 - 01:42
march
User
18/08/2018 - 01:42
etc
Excelchat Expert
18/08/2018 - 01:42
Count or Sum
User
18/08/2018 - 01:42
i want the total for each month on sheet 1
Excelchat Expert
18/08/2018 - 01:42
Column L contains 1,1,1,2 etc.
Excelchat Expert
18/08/2018 - 01:42
Ok.
User
18/08/2018 - 01:42
yes so would be sum i agree
User
18/08/2018 - 01:42
but how do i do it so it only selects Jan and not any other month?
User
18/08/2018 - 01:43
bec the data has other months
Excelchat Expert
18/08/2018 - 01:43
Month - I need to consider column A
Excelchat Expert
18/08/2018 - 01:43
I will take care
User
18/08/2018 - 01:44
can you give me the formula how to do this please?
Excelchat Expert
18/08/2018 - 01:44
Sure.
Excelchat Expert
18/08/2018 - 01:48
One minute. I am working with your excel file
Excelchat Expert
18/08/2018 - 01:48
Just give me two minutes
User
18/08/2018 - 01:48
yes sure
Excelchat Expert
18/08/2018 - 01:49
FYI
[Uploaded an Excel file]
Excelchat Expert
18/08/2018 - 01:50
Please download this sheet and check the result
Excelchat Expert
18/08/2018 - 01:50
Are you there?
User
18/08/2018 - 01:51
ok but i dont see the formula us used to get this?
User
18/08/2018 - 01:51
nope sorry i go tit
Excelchat Expert
18/08/2018 - 01:51
Ok Thank you
Excelchat Expert
18/08/2018 - 01:52
=Sumifs Formula will help you to add the values
User
18/08/2018 - 01:52
ok that makes sense
User
18/08/2018 - 01:52
this is good
Excelchat Expert
18/08/2018 - 01:52
Cool :)
User
18/08/2018 - 01:52
is this 24/7 service?
Excelchat Expert
18/08/2018 - 01:52
yes.
Excelchat Expert
18/08/2018 - 01:52
Anytime you can connect with us and solve your problem.
User
18/08/2018 - 01:52
how do i register ?
User
18/08/2018 - 01:52
how much isit?
Excelchat Expert
18/08/2018 - 01:52
One question / Session.
Excelchat Expert
18/08/2018 - 01:53
am not sure about the payment
Excelchat Expert
18/08/2018 - 01:53
Please register you will get lot of offers as well.
User
18/08/2018 - 01:53
ok ill have a browse
User
18/08/2018 - 01:53
i have already registered :-)
Excelchat Expert
18/08/2018 - 01:53
Sure. Thanks. Have a nice day
User
18/08/2018 - 01:53
thank you for all your help
Excelchat Expert
18/08/2018 - 01:53
Please provide your valuable feedback and remarks
User
18/08/2018 - 01:53
i will do
User
18/08/2018 - 01:54
thank 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.