Ignoring Cells w/ Formulas Returning "Blank"

[Voski]

It seems like ignoring these cells in arrays, lookups, filter, sumproduct, etc is not very intuitive. Any suggestions or advice on my solution below? Seem ironic that Excel's treatment of ISBLANK and COUNTBLANK conflict. 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)

 

[Fluff]

Duplicate to: Ignoring Cells w/ Formulas Returning "Blank"

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.