# Excel - COLUMN Function Problem - Expert Solution

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

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.