Addition formula

[snjpverma]

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.

	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

 

[snjpverma]

jkatw, this is the perfect solution..
The formula you gave earlier were working fine, but not in all the scenarios. This one is working fine for all the scenarios.
I have been trying to achieve this result for almost a week now. Finally, you helped me solve this.
Thanks a ton.

 

[snjpverma]

jkatw, this couldn't have been done better. Brilliant!!

 

[jtakw]

Thank you and you're welcome, glad it's working for you and solved your problem.