How do I set up a daily average of unit sales formula

[Guest]

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?

 

[Richard Buttrey]

On Mon, 7 Nov 2005 14:12:03 -0800, "jim m" <jim

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?

More than likely, but can I suggest you post a simple example of your
data, showing the result you expect.

It's likely that a function would achieve this, but are you seeking a
VBA macro given the group you've posted to?

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Guest]

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