ExcelBanter

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

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

- - sum (https://www.excelbanter.com/excel-worksheet-functions/8905-sum.html)

larry

sum

in the fx =sum(f5:f56) I get ##### instead of amumber

Biff

Hi!

That means either the column isn't wide enough or the sum
is a negative date/time value.

If the values aren't date/time values, widen the column!

Biff

-----Original Message-----
in the fx =sum(f5:f56) I get ##### instead of amumber
.

All times are GMT +1. The time now is 02:35 AM.