Ref attached sample sheet and Column E40 which is sum.
I need to change this sum as under.
If each row i.e, E17 to E39 is more than corresponding D17 to D39
then it should sum based on corresponding D
Ex: E 35 is more than D35, so in sum it should consider E35 as 6 which is in D35
So the sum in E40 should be 44 instead of 45
Bookmarks