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