| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum function failure
"HighFlier22" wrote:
It's pretty simple: =SUM(I710:L710) If it's not calc mode issue, maybe the "numbers" in I710:L710 are text numbers? Try this which will coerce all to real numbers, array-entered (press CTRL+SHIFT+ENTER to confirm the formula): =SUM(I710:L710+0) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| failure of web query | Excel Discussion (Misc queries) | |||
| Create a function to calculate Mean time Before Failure | Excel Worksheet Functions | |||
| sumproduct failure? | Excel Discussion (Misc queries) | |||
| AutoFilter Failure | Excel Worksheet Functions | |||
| Calculation Failure | Excel Discussion (Misc queries) | |||
Hybrid Mode
