I find ignoring blank cells with formulas in lookup ranges, sumproduct, filter etc not very intuitive. Can anyone offer any advice or other simple solutions to this common problem other than this? COUNTBLANK seems to work and flags them correctly. Seems ironic that COUNTBLANK and ISBLANK conflict w/ each other. Thanks.
Column A | Random #s | Column E | ||
Row 24 | 1 | 1 | 0 | 0 |
Row 25 | 2 | 2 | 0 | 0 |
Row 26 | 3 | 3 | 0 | 0 |
Row 27 | 4 | 4 | 0 | 0 |
Row 28 | 11 | 0 | 1 | |
Row 29 | 12 | 0 | 1 | |
Row 30 | 13 | 0 | 1 | |
Row 31 | 14 | 0 | 1 | |
| =IF(B31<10,B31,"") | =ISBLANK(C31)*1 | =COUNTBLANK(C31) |
