Subtotal Non-contiguous cells

[David N. Ballew Jr.]

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]

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.]

When I use the sum function, I get the proper answer, which is currently 7.
The contents of the cells referred to in the formula I am trying to get to
work are subtotal formulas. They work as advertised because the data they are
subtotaling is contiguous.

 

[Dave Peterson]

Ah...

I missed that in your original message (subtotals of subtotals).

You've seen that =subtotal() ignores other =subtotals()

I don't have a suggestion for you.

But if you don't get an answer here, you may want to declare this thread dead
and repost your question in the .worksheet.functions newsgroup.

There's some very smart people that can do lots of weird (good for you!) stuff
with hidden cells. (I ain't one of them, though.)