ExcelBanter - =+SUM(S2:S36) outputs 19190fault

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - =+SUM(S2:S36) outputs 19190fault (https://www.excelbanter.com/excel-worksheet-functions/170044-%3D-sum-s2-s36-outputs-19190fault.html)

EBux

=+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?

Gord Dibben

=+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?

All times are GMT +1. The time now is 03:24 AM.