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.

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.

SUMIF except for blank cells
 

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)

SUMIF except for blank cells
 

=SUMIF(F3:F160,"",D3:D160)

--
__________________________________
HTH

Bob

<Tony Charlton wrote in message
...
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)