if you use:
=sum(h6,h54,h75,h83,h88)

what do you get?

I'm guessing that your data isn't really numbers--it's text that look like
numbers.



David N. Ballew Jr. wrote:

I am trying to figure out the syntax for a subtotal formula that subtotals
non-contiguous cells. I am using Excel 2003. Ex.
=subtotal(109,h6,h54,h75,h83,h88). I want the first argument set to 109 so
that if I manually hide one of the rows mentioned in the formula, then the
subtotal reflects the loss of the cell. Is what I am trying to do impossible?
I don't get an error indication; the answer is always 0.

--

Dave Peterson