What result are you getting? Perhaps some of the values in column B are the
result of a formula. If there are any errors in the column, then your SUM
formula may also produce an error. There may be other ways to test column B
for errors, but here's one way.

=SUMPRODUCT(--(ISERROR(B2:B248)))

If the result is greater than zero, then there is that many cells in your
range that result in an error.

Does that help?
Paul

--

"Randy Rich" wrote in message
...
I am struggling to get a column of talk times from our call center to total
up. The format is 0:00:05, for example, and represents the output from
the
phone equipment. The report shows the agent name, and the total talk
time.
I'm interested in getting a total off all the time all the agents spent on
the phone, and I'm stumped. It just won't =sum(b2:b248). It will do
=b2+b3+b4, but that is going to be difficult when the report is several
thousand entries long. I can use a different column, and get running
totals,
but I am puzzled why I can't just get a total from the column. Does
anyone
have any insight into the workings of Excel 2007?
--
Thanks, Randy