I want to calculate the total number of shortage. Please help me with a formula to do so. The excess should get adjusted with the forthcoming shortages. I am OK with using helper cells.
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col...