When counting blanks as 0, orders increased from 18 to 32 rows

In inventory or application tables, how do averages and ordering decisions change if you aggregate without distinguishing between blanks, 0, and "not yet counted"? This article is written for those ...