Thread: Sumif function does not add up cells, even when criteria is blank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beckster
 
Posts: n/a
Default Sumif function does not add up cells, even when criteria is blank
I have a range of cells which retrurn a value if I use the Sum function.
They are all formatted as numbers. However if I use Sumif it always returns
zero, even if I leave the criteria blank to sum all cells.
Reply With QuoteReply With Quote