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 style="width:97px;"><col style="width:64px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
A | B | C | |
1 | Day | To be given | received |
2 | 1st Day | 3 | 4 |
3 | 2nd Day | 3 | 2 |
4 | 3rd Day | 3 | 2 |
5 | 4th Day | 3 | 1 |
6 | |||
7 | Total Shortage |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:97px;"><col style="width:64px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Last edited: