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.
Please ignore my answer... I had someone (the wife<g) "gently" requesting
my presence elsewhere and I rushed the answer without thinking.
..
Rick
|