Subtotal Function is Inconsistent
 

I'm using =SUBTOTAL(9,A8:IU8) on a large row of cells. This large row of
cells contains many sum functions. On some spreadsheets, the subtotal only
counts the sum cells. On others, it counts everything. How can I control
this?

Paste the following into cell A1 of a blank spreadsheet. All of the below
should be on the same row.
1 5 6 =SUM(A1:C1) 3 9 2 =SUM(E1:G1) =SUBTOTAL(9,A1:H1)

Shouldn't cell I1 = 26 instead of 52? I know it works sometimes.

Thanks!

Subtotal Function is Inconsistent
 

Use =SUBTOTAL(9,A1:C1) etc in place of SUM(), this's what it is designed
for.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"TKS_Mark" wrote in message
...
I'm using =SUBTOTAL(9,A8:IU8) on a large row of cells. This large row of
cells contains many sum functions. On some spreadsheets, the subtotal
only
counts the sum cells. On others, it counts everything. How can I control
this?

Paste the following into cell A1 of a blank spreadsheet. All of the below
should be on the same row.
1 5 6 =SUM(A1:C1) 3 9 2 =SUM(E1:G1) =SUBTOTAL(9,A1:H1)

Shouldn't cell I1 = 26 instead of 52? I know it works sometimes.

Thanks!

Subtotal Function is Inconsistent
 

No, SubTotal ignores previous Subtotals not Sums.

--
__________________________________
HTH

Bob

"TKS_Mark" wrote in message
...
I'm using =SUBTOTAL(9,A8:IU8) on a large row of cells. This large row of
cells contains many sum functions. On some spreadsheets, the subtotal
only
counts the sum cells. On others, it counts everything. How can I control
this?

Paste the following into cell A1 of a blank spreadsheet. All of the below
should be on the same row.
1 5 6 =SUM(A1:C1) 3 9 2 =SUM(E1:G1) =SUBTOTAL(9,A1:H1)

Shouldn't cell I1 = 26 instead of 52? I know it works sometimes.

Thanks!

Subtotal Function is Inconsistent
 

Thanks.

"Sandy Mann" wrote:

Use =SUBTOTAL(9,A1:C1) etc in place of SUM(), this's what it is designed
for.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"TKS_Mark" wrote in message
...
I'm using =SUBTOTAL(9,A8:IU8) on a large row of cells. This large row of
cells contains many sum functions. On some spreadsheets, the subtotal
only
counts the sum cells. On others, it counts everything. How can I control
this?

Paste the following into cell A1 of a blank spreadsheet. All of the below
should be on the same row.
1 5 6 =SUM(A1:C1) 3 9 2 =SUM(E1:G1) =SUBTOTAL(9,A1:H1)

Shouldn't cell I1 = 26 instead of 52? I know it works sometimes.

Thanks!

Subtotal Function is Inconsistent
 

Thanks.

"Bob Phillips" wrote:

No, SubTotal ignores previous Subtotals not Sums.

--
__________________________________
HTH

Bob

"TKS_Mark" wrote in message
...
I'm using =SUBTOTAL(9,A8:IU8) on a large row of cells. This large row of
cells contains many sum functions. On some spreadsheets, the subtotal
only
counts the sum cells. On others, it counts everything. How can I control
this?

Paste the following into cell A1 of a blank spreadsheet. All of the below
should be on the same row.
1 5 6 =SUM(A1:C1) 3 9 2 =SUM(E1:G1) =SUBTOTAL(9,A1:H1)

Shouldn't cell I1 = 26 instead of 52? I know it works sometimes.

Thanks!