This works for both empty cells and cells that contain formula blanks
(appear empty):

=SUMIF(A1:A10,"",B1:B10)

--
Biff
Microsoft Excel MVP


"fgrose" wrote in message
...
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.