average

[s.k.h]

i have a summary of sales statement like jan 5 ,feb 5 ,mar 5 , apr 5, jun 5
, jul 5, aug 5 , sep 5, oct 5 , nov 5 , dec 5 and after that we do total for
all 12 months 60
so now we find average
like this =average(.........) all numbers
but if we dont have a sell in jan month n we dont have a sell in feb month
so remaining 10 months so shown me in total only 10 months sale not 12
months sale autometically we generate only once time formula either we have a
sell in jan month or either we have a sell in feb months
i also try this formula
total/count(...........)
or if formula
if(ref>0,ref/12,if(ref>0,ref/11

 

[Mary Sauer]

This certainly isn't a Publisher function.
Try this newsgroup:
http://www.microsoft.com/communitie...9ec-14bf-4ef7-ba07-6a1970559f64&lang=en&cr=US