I want to add the numbers in a column that are in cells that are not filled.
I tried the formula: =SUMIF(A2:A5,"no fill") and got the result, 0. A2:A5 is
the range and "no fill" is the criteria. I'm thinking that I'm not using the
correct text for the criteria. Can someone help me?