SUMIF except for blank cells

  • Thread starter Thread starter Hagridore
  • Start date Start date
H

Hagridore

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.
 
Not sure if this could be of help but I wanted the sum of a column where another column (Paid Date) was empty to give me an outstanding balance. I am sure there is a way of doing it in one sumif statement but a simple subtraction got the job done for me??

=SUM(D3:D160)-SUMIF(F3:F160,"<>",D3:D160)
 
Back
Top