View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Richard Buttrey Richard Buttrey is offline
external usenet poster
 
Posts: 296
Default How do I set up a daily average of unit sales formula

On Mon, 7 Nov 2005 14:12:03 -0800, "jim m" <jim
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?



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
__________________________