I am trying to figure out the syntax for a subtotal formula that subtotals
non-contiguous cells. I am using Excel 2003. If I use the Sum function as in
the following formula: =SUM(H6,H54,H75,H83,H88), I get the expected answer,
but I want to use the Subtotal function so my formulas results will reflect
that one or more of the cells referenced in the formula has been manually
hidden. Subtotal formula example: =SUBTOTAL(109,h6,h54,h75,h83,h88). Is what
I am trying to do impossible? I don't get an error indication; the answer is
always 0. And by the way, the cells referenced in the subtotal and sum
formulas are themselves subtotals, but they work as advertised because the
cells they refer to are contiguous.

The subtotal function ignores any other subtotals... so selecting ONLY
subtotals will give you zero.
=subtotal(109,H2:H88) to get the total of visible rows in that range.

"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. If I use the Sum function as in
the following formula: =SUM(H6,H54,H75,H83,H88), I get the expected answer,
but I want to use the Subtotal function so my formulas results will reflect
that one or more of the cells referenced in the formula has been manually
hidden. Subtotal formula example: =SUBTOTAL(109,h6,h54,h75,h83,h88). Is what
I am trying to do impossible? I don't get an error indication; the answer is
always 0. And by the way, the cells referenced in the subtotal and sum
formulas are themselves subtotals, but they work as advertised because the
cells they refer to are contiguous.

Thank you very much! It worked like a champ.

Dave

"BoniM" wrote:

The subtotal function ignores any other subtotals... so selecting ONLY
subtotals will give you zero.
=subtotal(109,H2:H88) to get the total of visible rows in that range.

"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. If I use the Sum function as in
the following formula: =SUM(H6,H54,H75,H83,H88), I get the expected answer,
but I want to use the Subtotal function so my formulas results will reflect
that one or more of the cells referenced in the formula has been manually
hidden. Subtotal formula example: =SUBTOTAL(109,h6,h54,h75,h83,h88). Is what
I am trying to do impossible? I don't get an error indication; the answer is
always 0. And by the way, the cells referenced in the subtotal and sum
formulas are themselves subtotals, but they work as advertised because the
cells they refer to are contiguous.