**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.*