subtotal sums
 

Stupid question here.

I have a column of numbers, with =SUMon various rows.
I am trying to use the =subtotal(9,x;z) formula. The result is NOT stripping
out the =SUM amounts.

What am I doing wrong?

Thanks in advance for your help.

JIMK

subtotal sums
 

If you want to ignore your cells with =sum() formulas, you'll have to change
them to =subtotal(), too.

JIMk wrote:

Stupid question here.

I have a column of numbers, with =SUMon various rows.
I am trying to use the =subtotal(9,x;z) formula. The result is NOT stripping
out the =SUM amounts.

What am I doing wrong?

Thanks in advance for your help.

JIMK

--

Dave Peterson

subtotal sums
 

Thanks Dave.

"Dave Peterson" wrote:

If you want to ignore your cells with =sum() formulas, you'll have to change
them to =subtotal(), too.

JIMk wrote:

Stupid question here.

I have a column of numbers, with =SUMon various rows.
I am trying to use the =subtotal(9,x;z) formula. The result is NOT stripping
out the =SUM amounts.

What am I doing wrong?

Thanks in advance for your help.

JIMK

--

Dave Peterson