| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=+SUM(S2:S36) outputs 19190fault
When I use a sum or a count command (or any calculation), I get a ######fault
output. What is causing this in this worksheet? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=+SUM(S2:S36) outputs 19190fault
With numbers it generally means the column needs widening.
Set the columns to autofit selection. Gord Dibben MS Excel MVP On Mon, 17 Dec 2007 13:54:34 -0800, EBux wrote: When I use a sum or a count command (or any calculation), I get a ######fault output. What is causing this in this worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fast Fourier Transform outputs in Excel | Excel Worksheet Functions | |||
| conditinal If statement with 3 outputs | Excel Worksheet Functions | |||
| Sumif outputs values | Excel Discussion (Misc queries) | |||
| Using solver with function with multiple outputs | Excel Worksheet Functions | |||
| I a formula that outputs the number of occurances of a specific t. | Excel Discussion (Misc queries) | |||
Linear Mode
