Thanks for that test PCLIVE, but my result was 0. I've got to believe it is
something to do with the data format, but I honestly can't tell what it is.
I've tried a bunch of different cell formats, hoping each one will give me
the total I need. I end up with something that says 12:00:00 AM or something
similar. I even ran a pivot table, trying to get it to sum that way. One
agent got a 5 second total. Everyone else was zero. I tried to find out
which entry at least got me a 5, and from what I can tell it was the one I
entered by hand. However, it seems to work flawlessly when I do the
additional column and get the 'running total' - so selecting individual cells
seems to work. Highlighting the column gives me the 'count' at the bottom of
the page, but not the sum or the average. It's frustrating.
--
Thanks, Randy


"PCLIVE" wrote:

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