My Average function becomes #Name? Pls help :(

[Lewis Koh]

Hi,

I used to have a column with the function below.
=B84/DAY(EOMONTH(B1,0))

B84=1000,
DAY(EOMONTH(B1,0)) supposed to count the number of days of the specifi
month where B1 = "1/09/2005".

I have 12 Tabs from Jan to Dec. I imported this excel file from my ol
pc and suddenly, all my average became "#Name?". Do I need to d
something before this function can works?

Does anyone has a better formula to do the above average?? Pls help

 

[Roger Govier]

Hi Lewis

It sounds as though you don't have the Analysis Toolpak loaded.
Tools>Addins>click Analysis Toolpak then EOMONTH will be included.

Regards

Roger Govier

 

[Anne Troy]

Sounds like you need to go to Tools-->Addins and turn on the Analysis
Toolpak
************
Anne Troy
www.OfficeArticles.com

 

[Lewis Koh]

oh yah. Thanks. I remembered I did it once on my old pc. Thanks Anne. :

 

[Anne Troy]

You're welcome, Lewis!
************
Anne Troy
www.OfficeArticles.com