Thread: sumif
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dkline Dkline is offline
external usenet poster
  
Posts: 75
Default sumif
=SUMIF(range of cells,"<0")

"VielExcel" wrote:


Hi all,

I would like to know the sumif formula if I want to add all values 0,
or all negative values in a column.




--
VielExcel

Reply With QuoteReply With Quote