 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
08-28-2008, 09:20 AM
|
|||
|
|||
|
Problems with basic function average
Hi
I have dumped a load of data from my mrp system into excel for analysis. I have a problem that when I go to select data for an average I get a #div0# error. When I go to do the average by selecting the area above my bottom task bar the average function is missing and I can only choose count. Could you please help. Thanks Brian 
|
|
08-28-2008, 10:17 PM
|
|||
|
|||
|
RE: Problems with basic function average
Hello Brian
You should make sure that the numbers are real numbers, and not some "textnumbers" (they're text and not numbers) -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "brian.baker13@googlemail.com" wrote: > Hi > > I have dumped a load of data from my mrp system into excel for > analysis. > > I have a problem that when I go to select data for an average I get a > #div0# error. When I go to do the average by selecting the area above > my bottom task bar the average function is missing and I can only > choose count. > > Could you please help. > > Thanks > > Brian >
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
