So that tells you the problem. If you look at help for the SUBTOTAL
function, it wants 2 arguments, the second of which is the range that you
want to total. In your case, that argument is missing. I would normally
use the SUM function, rather than SUBTOTAL, but I don't know the structure
of your data.
--
David Biddulph

"Carol" wrote in message
...
Sorry, but I was using the AutoSum. The formula that it automatically
inserts is: =SUBTOTAL(9,)

"David Biddulph" wrote:

You didn't tell us what your formula was, so it is rather difficult for
us
to tell you what your error is.
--
David Biddulph

"Carol" wrote in message
...
I have a column of numbers formatted as h:mm and I want a sum. I have
read
the posts about formatting the result cell with brackets around the h.
When
I do this, and use the autosum button, I get the pop-up message that
there
is
an error in my formula. Any suggestions?