| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why do I get #NUM! for a GEOMEAN calc on a set of positive vals
I have a set of around 400 values in a sheet which range between 1 and
200,000. When I try to calculate the GEOMEAN value I get a #NUM! result. If I calculate the accumulating GEOMEAN (A1:A1, A1:A2, A1:A3 etc.) I find that the #NUM! starts when I hit the 174th item, which looks normal at about 139. If I calculate the GEOMEAN in chunks of 50 values (A1:A50, A2:A51, A3:A52 ... A150:A199 etc.) the calculation goes past this 174th item with no problems. If I manually edit the value, I can set it to any number from 0 to 51 and the calculation will take place correctly; however, the #NUM! returns at the calculation of the 175th item. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I write a VLOOKUP function that returns 0's, not neg vals? | Excel Worksheet Functions | |||
| auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
| GEOMEAN Function | Excel Worksheet Functions | |||
| How get rid of these errors if cell has no vals? | Excel Worksheet Functions | |||
| Geomean range | Excel Worksheet Functions | |||
Threaded Mode
