View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lehigh46 lehigh46 is offline
external usenet poster
 
Posts: 43
Default Subtotaling minus negative numbers and posative numbers

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