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?