View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default test expression for empty cell in =SUMIF()

How does one test for an empty worksheet cell in the array-type
criteria for worksheet functions like =SUMIF() ?

=SUMIF(range,"=""",sum_range) does not seem to work for me.


Do you really need SUMIF? What is wrong with using this?

=SUM(Sum_Range)

Empty cell are not a problem to it.

Rick