ageing Report with correct amount in correct age field

[Love.com]

Dear sir
please help....

My Data
Total <=15 days 16-30 days 31-45 days 46-60 days 61-90 days 91-180 day 181-360 days >360 days
300 100 0 -50 0 -50 0 400 -100
350 0 50 150 150 -50 -50 100 0
400 0 100 0 0 -100 -100 150 350
650 -100 150 150 600 0 0 -150 0

I Want This
Total <=15 days 16-30 days 31-45 days 46-60 days 61-90 days 91-180 day 181-360 days >360 days
300 100 0 0 0 0 0 200 0
350 0 50 150 150 0 0 0 0
400 0 100 0 0 0 0 150 150
650 0 150 150 350 0 0 0 0
Currently what I do
1 Simply I am adding negative value in positive as per first in first out basis
2 in >360 Days have "-100" add in 180-360 days then value become "+300"
3 in 61-60 Days have "-50" add in 180-360 Days then value become "+250"
4 in 31-45 Days have "-50" add in 180-360 Days then value become "+200"
5 <=15 Days have "+100"
6 now total out-Standing is 300 ["100" is in <=15 Days & "200" is in 180-360 Days]

 

[John Jairo V]

Hi, Love.com!

You could try this formula:
[B11] : =MAX(,B3+SUMIF($B3:$I3,"<0")+SUMIF(C3:$J3,">0")-SUM(C11:$J11))

Check file. Blessings!

 

[Love.com]

Hi, Love.com!

You could try this formula:
[B11] : =MAX(,B3+SUMIF($B3:$I3,"<0")+SUMIF(C3:$J3,">0")-SUM(C11:$J11))

Check file. Blessings!

Thank you so much.....its working....great.......
need one more help.....could you please explain this formula......??

 

[GraH - Guido]

Hi, Love.com, sometimes formulae posted here are "creative", and I do not mean that in any ironic way, it is just a very "new" approach which is not looking familiar (yet) to basic users. John is one of those, able to surprise us all with his formula wit.

Because this formula is doable for "self service learning", try to use the Evaluate Formula feature. It is on the formula ribbon, the formula audit section. See #10 in this earlier thread.
https://chandoo.org/forum/threads/if-formula-required.37320/#post-224310

 

[Love.com]

Hi, Love.com, sometimes formulae posted here are "creative", and I do not mean that in any ironic way, it is just a very "new" approach which is not looking familiar (yet) to basic users. John is one of those, able to surprise us all with his formula wit.

Because this formula is doable for "self service learning", try to use the Evaluate Formula feature. It is on the formula ribbon, the formula audit section. See #10 in this earlier thread.
https://chandoo.org/forum/threads/if-formula-required.37320/#post-224310

i am appreciate dear john jairo as well what you suggest.....thanks a ton both of you...