test expression for empty cell in =SUMIF()
If your range is A1:A10 and the range you want to sum is B1:B10 use this:
=SUMIF(A1:A10,"",B1:B10), this will return the sum of the numbers in B1 thru
B10 that have corresponding empty cells in A1 thru A10. If you simply want
to count the empty cells in A1 thru A10, use: =COUNTIF(A1:A10,"")
"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.
|