View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hagridore Hagridore is offline
external usenet poster
 
Posts: 1
Default SUMIF except for blank cells

Okay...I am trying to create a SUMIF statement where the criteria is not
blank. I can't figure out how. I have tried "<""". Is there a NOTBLANK
function like BLANK? This would be, for example, the formula I would use on
a report sheet in a workbook where I list the daily sales of a sales team. I
want the sum to ignore all the team members who haven't made sales for that
day, and just give me the sum of those who have.