View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Negative values in a formula

trY:

=SUMIF(A1:A50,"0")

"Susan" wrote:

How do you enter a formula to add the value of cells in a column, but minus
negative values in the column?

Susan