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.