**Question description:**

*This user has given permission to use the problem statement for this blog.*

how do I derive the monthly sales from a date and revenue column

Solved by A. U. in 23 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
08/10/2018 - 01:22

Good Morning

Excelchat Expert
08/10/2018 - 01:22

I welcome you in Excel chat

Excelchat Expert
08/10/2018 - 01:22

Could you please provide me little more details about the challenges you are facing while using Match formula?

User
08/10/2018 - 01:22

good morning

Excelchat Expert
08/10/2018 - 01:23

Can you provide me your spreadsheet? I think you should be using Sumif function to get the total

User
08/10/2018 - 01:23

I am trying to figure out how to calculate monthly sales from the date column (ex 01/01/18) and the revenue column

Excelchat Expert
08/10/2018 - 01:23

I ensure you for the full solution however I need to check your data first

Excelchat Expert
08/10/2018 - 01:24

Yes, So for this you should be using Sumifs formula where we will using Data Range as a Criteria and Revenue Column as Sum. So for that particular data range you will get the sum

User
08/10/2018 - 01:24

here it is

[Uploaded an Excel file]

Excelchat Expert
08/10/2018 - 01:24

If you want, I can create this formula for you in your spreadsheet or on any dummy data

User
08/10/2018 - 01:24

yes that would be great

Excelchat Expert
08/10/2018 - 01:25

Thanks for providing me this file. Let me have a look

Excelchat Expert
08/10/2018 - 01:25

I have opened your file. Please advise, where do you want me to put this formula

User
08/10/2018 - 01:26

in the MONTH column

Excelchat Expert
08/10/2018 - 01:27

But this is your database and we need to have specific month or data range to get the Sum

Excelchat Expert
08/10/2018 - 01:27

Shall I create a separate tab for you where you can enter date range and get the total respect to that particular date range?

Excelchat Expert
08/10/2018 - 01:28

You there??

User
08/10/2018 - 01:28

I am not sure what you mean

Excelchat Expert
08/10/2018 - 01:28

In month range, do you want to calculate the sum of revenue?

User
08/10/2018 - 01:28

sorry - had to run to the bathroom

User
08/10/2018 - 01:28

yes

User
08/10/2018 - 01:28

sum of revenue per month

User
08/10/2018 - 01:29

I was trying to create a formula base on the date column

Excelchat Expert
08/10/2018 - 01:29

but we have 12 months and you have multiple rows. That is your database actually

Excelchat Expert
08/10/2018 - 01:29

Shall I create a separate tab for you and there you can get monthly total revenue?

Excelchat Expert
08/10/2018 - 01:29

Is that okay

User
08/10/2018 - 01:30

Yes that will be fine

Excelchat Expert
08/10/2018 - 01:30

Okay

User
08/10/2018 - 01:30

sorry ...slow internet

Excelchat Expert
08/10/2018 - 01:30

Please allow me few minutes. I will solve this

User
08/10/2018 - 01:30

ok thanks

Excelchat Expert
08/10/2018 - 01:35

Here you go

[Uploaded an Excel file]

Excelchat Expert
08/10/2018 - 01:35

You should check Monthly Revenue tab

Excelchat Expert
08/10/2018 - 01:36

You need to enter the year for which you want to check Revenue on a Monthly basis

Excelchat Expert
08/10/2018 - 01:36

Once you enter the year, you will be able to see the Revenue Sum for that Respective period

User
08/10/2018 - 01:37

okay...thanks - but could not download spreadsheet

Excelchat Expert
08/10/2018 - 01:37

I used Sumifs formula to calculate the Revenue.

User
08/10/2018 - 01:37

how do I enter the year

Excelchat Expert
08/10/2018 - 01:37

Just enter the year on Cell B1

User
08/10/2018 - 01:37

ok thanks

Excelchat Expert
08/10/2018 - 01:38

Please advise, if its working fine for you

User
08/10/2018 - 01:39

okay I have a problem

User
08/10/2018 - 01:39

or really comprehension problem

Excelchat Expert
08/10/2018 - 01:39

yeah tell me

User
08/10/2018 - 01:39

so ..how do I capture all the information in one column

Excelchat Expert
08/10/2018 - 01:39

Okay is it related to the same problem which we were discussing or it is something else?

User
08/10/2018 - 01:40

same

Excelchat Expert
08/10/2018 - 01:40

What information do you want to capture in one column?

User
08/10/2018 - 01:40

the monthly sales

User
08/10/2018 - 01:41

you put it on another page - which I love but they want it in one column

Excelchat Expert
08/10/2018 - 01:41

Okay. So that information will be repeated, if the same month date occurs in date Column

User
08/10/2018 - 01:41

okay....let me back up for a second

Excelchat Expert
08/10/2018 - 01:41

So for example, if you see A2 and A3 cell on Salestable tab

User
08/10/2018 - 01:42

the column on the worksheet - MONTH should contain the monthly sales

Excelchat Expert
08/10/2018 - 01:42

Those are same month's date. So month column will repeat the Revenue total.

Excelchat Expert
08/10/2018 - 01:42

I will do that but are you comfortable using the repeated information

Excelchat Expert
08/10/2018 - 01:43

Please advise

User
08/10/2018 - 01:45

I have what I need. Thank you so very much.

Excelchat Expert
08/10/2018 - 01:45

Okay Does it solve your problem

User
08/10/2018 - 01:45

I explained to the "powers to be" what you did

User
08/10/2018 - 01:45

yes it does

Excelchat Expert
08/10/2018 - 01:45

Thank you so much

Excelchat Expert
08/10/2018 - 01:45

Could you please end the session please?

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