Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set up a daily average of unit sales formula
Tracking unit sales per day, I would like to input the total number of units
sold and in a seperate cell have the average unit sales per day automatically calculate, and then in another cell automatically calculate the number of units we are tracking for thru the end of the month. IS THIS POSSIBLE? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set up a daily average of unit sales formula
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set up a daily average of unit sales formula
Hi,
How is you data organized? Assumptions: - you have 1 entry per day per product - Products are listed in column A, say A2:A100 - Days are listed in row 1, say B1:AF1 -- therefore sales data are entered in B2:AF100 1. Total number or product sold per product - in AG2, enter the formula: = SUM( $B2:$AF2 ) - copy AG2 and paste it down along the data 2. Daily Average sales per product - in AH2 , enter the formula: = AVERAGE( $B2:$AF2 ) - copy AH2 and paste it down along the data you get the idea -- Regards, Sébastien <http://www.ondemandanalysis.com "jim m" wrote: Tracking unit sales per day, I would like to input the total number of units sold and in a seperate cell have the average unit sales per day automatically calculate, and then in another cell automatically calculate the number of units we are tracking for thru the end of the month. IS THIS POSSIBLE? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sales history and how Unit Price affects it... | Charts and Charting in Excel | |||
Daily Sales to Date calculation | Excel Discussion (Misc queries) | |||
How do I set up a daily average of unit sales formula | Excel Discussion (Misc queries) | |||
track daily sales | Excel Discussion (Misc queries) |