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? |
How do I set up a daily average of unit sales formula
|
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? |
All times are GMT +1. The time now is 05:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com