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.
|