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
Please try in E40 an copy to right:Formula:
Please Login or Register to view this content.
Thanks a TON !
You are welcome, glad to have helped and thanks for the feedback and rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks