adrecal
asked on
Average with date interval and product code
Hello :-)
I have an excel spreadsheet where there is a product code and the sales amount of that product per day. I need to take the average sales per day range for a given product. How many sales for product 01 between 10/11 and 02/12 for example.
Some idea?
The spreadsheet:
I have an excel spreadsheet where there is a product code and the sales amount of that product per day. I need to take the average sales per day range for a given product. How many sales for product 01 between 10/11 and 02/12 for example.
Some idea?
The spreadsheet:
Last Comment
ASKER
Is it okay to rearrange the data as suggested?
Try this
Formulas on sheet COMPRA.
Total in column G, and average in column H.
Date limits in G1 and H1.
ESTOQUE.xlsx
Formulas on sheet COMPRA.
Total in column G, and average in column H.
Date limits in G1 and H1.
ESTOQUE.xlsx
See attached, New sheet with re-arranged data in a table and a pivot table summarising.
There are drop-downs so that you can filter on code or dates.
ESTOQUE.xlsx
There are drop-downs so that you can filter on code or dates.
ESTOQUE.xlsx
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you guys! The second sheet from Rob did the trick, but the Ejgil sheet is amazing too.
Glad it worked for you.
Thanks for the feedback.
Thanks for the feedback.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Ideal would be arranged in 3 columns:
Code Date Quantity
Can you upload a sample file rather than screenshot?