My Average function becomes #Name? Pls help :(

L

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
 
R

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
 
Top