Excel formula to show sales per month from movement per day
- or -
Post a project like this1028
£30(approx. $38)
- Posted:
- Proposals: 30
- Remote
- #3325174
- Awarded
Excel | Google Sheets | Google Apps Script Automation | VBA Macro | Dashboard | Data Analysis
Karachi
503038855762643839545387944349994105270488536505055069786022448592621159221336109271
Description
Experience Level: Entry
Advanced Excel formula needed to show sales per month with a line chart to show month date vs sales per month
Example data set attached. This is sales data for one product. I have 22 products from this supplier. I need to use this data to forecast stock ordering for next year by analyzing sales per month. The chart will therefore need to show sales trend lines for 22 products.
I understand there is a formula which can find the start and end of each month, i.e. 1st March to 31st March and then total how many sales for that month. I then need the line chart on the same sheet.
It would also be useful to have total sales per year
I may send the other 21 products to add to this sheet after this 1st product is set up.
Example data set attached. This is sales data for one product. I have 22 products from this supplier. I need to use this data to forecast stock ordering for next year by analyzing sales per month. The chart will therefore need to show sales trend lines for 22 products.
I understand there is a formula which can find the start and end of each month, i.e. 1st March to 31st March and then total how many sales for that month. I then need the line chart on the same sheet.
It would also be useful to have total sales per year
I may send the other 21 products to add to this sheet after this 1st product is set up.
Projects Completed
47
Freelancers worked with
32
Projects awarded
69%
Last project
30 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies