SUMIF except for blank cells
Try it like this:
=SUMIF(A1:A10,"<",B1:B10)
--
Biff
Microsoft Excel MVP
"Hagridore" wrote in message
...
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.
|