Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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)
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,420
Default 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)



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMIF does not work with blank cells uncreative Excel Discussion (Misc queries) 3 August 23rd 07 07:36 PM
Sumif to return a blank if sum range is blank [email protected] Excel Worksheet Functions 3 May 25th 06 10:25 AM
Sumif Cells Are Not Blank Powlaz Excel Worksheet Functions 12 March 15th 06 05:40 PM
Sumif function does not add up cells, even when criteria is blank Beckster Excel Worksheet Functions 5 January 13th 06 07:24 PM
Using SUMIF with non-blank cells Peter Aitken Excel Worksheet Functions 7 February 10th 05 03:11 PM


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"