I bet you get a better answer than this, but you could always insert an extra
column in your filtered range and use a formula like:

=if(a20,a2,"")

And use =subtotal() against that column.

And add a second column with a similar formula for the negative values.

lehigh46 wrote:

Hi All,

I have a column with a mix of positive and negative numbers.
What Subtotal formulas can I use to sum only the positive numbers and
a second formula below the first one to show negative numbers.
This column will be auto filtered so I need a "Subtotal" function.

Thanks for your help

Tom

--

Dave Peterson