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
I'm glad you liked it.
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
https://docs.google.com/spreadsheets/d/1V6ypeLRfo8SzWY_0IKg8Mx2M0pNcFquLFapXjL8M1do/edit#gid=0
Excelchat Expert
03/11/2017 - 10:01
You can download the sheet by going to the link above, clicking FILE > DOWNLOAD AS > Microsoft Excel (.xlsx)
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
https://drive.google.com/open?id=0B1j34SU3SZazNm11RkVzSnMydHc
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.