# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Could you help me with Column A "Date of Sale" Column B "Sales Â£" What is the excel formula for sales in january, sales in geb, sales in march etc etc? Many thanks
Solved by T. H. in 24 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 03/11/2017 - 09:41
Hello, I understand that you need help with summarizing your Sales data, right?
Excelchat Expert 03/11/2017 - 09:42
Are you there?
User 03/11/2017 - 09:43
hi yes
Excelchat Expert 03/11/2017 - 09:43
Alright, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question.
Excelchat Expert 03/11/2017 - 09:44
Does your data really have a lot of blank spaces in between?
User 03/11/2017 - 09:44
yes. DNP = Did not proceed.
Excelchat Expert 03/11/2017 - 09:45
Okay, what do we do with the data do not have dates in them?
Excelchat Expert 03/11/2017 - 09:45
The data you've provided isn't really ideal for creating a report so I need to clarify these things.
User 03/11/2017 - 09:46
We get paid commission when a sale completes. The date indicates that it has completed. If it has no date then cold we call it In Pipeline or TBC?
Excelchat Expert 03/11/2017 - 09:47
You will have to tag those as TBC. I can tag the ones you've placed here for now but moving forward, you will have to do so.
Excelchat Expert 03/11/2017 - 09:49
How do we calculate Totals sales?
Excelchat Expert 03/11/2017 - 09:49
Provider Commision + Client Fee?
User 03/11/2017 - 09:50
pls ignore client fee
Excelchat Expert 03/11/2017 - 09:51
Okay, this may take a while as your data isn't really ideal for creating a report.
Excelchat Expert 03/11/2017 - 09:51
An example would be your values aren't really numbers since they have the "£ " built in.
User 03/11/2017 - 09:53
DOES THAT HELP?
Excelchat Expert 03/11/2017 - 09:54
Yes that will help.
Excelchat Expert 03/11/2017 - 09:54
Give me a few minutes.
Excelchat Expert 03/11/2017 - 09:58
The DNP and TBC is done. I'm just working on the dates.
Excelchat Expert 03/11/2017 - 10:00
A gentle reminder that since you've extended the session: Please ensure that you end the session properly later or else I'll be stuck here waiting for the timer to expire and I'll be unable to help others.
Excelchat Expert 03/11/2017 - 10:00
Please see the formula in column G.
User 03/11/2017 - 10:00
many thanks. you're awesome. How d you make a living if this service is free?
Excelchat Expert 03/11/2017 - 10:01
The first session is free and then the next will be a paid service.
Excelchat Expert 03/11/2017 - 10:01
Excelchat Expert 03/11/2017 - 10:01
I'd appreciate a 5-star rating if you think I deserve it. :)
Excelchat Expert 03/11/2017 - 10:01
Excelchat Expert 03/11/2017 - 10:01
Excelchat Expert 03/11/2017 - 10:03
You may download this file too, it will have your file with the right formula in it.
Excelchat Expert 03/11/2017 - 10:03
User 03/11/2017 - 10:04
how do I 5 star you?
Excelchat Expert 03/11/2017 - 10:04
Are you still with me?
Excelchat Expert 03/11/2017 - 10:04
Once you end the session, you will get the chance to.
Excelchat Expert 03/11/2017 - 10:04
I'd appreciate that. It will help me a lot.
User 03/11/2017 - 10:04
cheers. How do you earn money?
Excelchat Expert 03/11/2017 - 10:05
The 5 star rating helps with that. :)
User 03/11/2017 - 10:05
if this service is free
User 03/11/2017 - 10:05
ok thanks Bye

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.