Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMaybe I'm reading too much into this but i think the real challenge/puzzle is to find out the way to do it WITHOUT macros and ALSO calculating the values AS PER the formula prescribed (in which values depend on the 2 other fields in the prior row). I suspect Patrick Digan (@patrick_digan) gives a tip under the 'Need a refresher' section.
I must admit i couldn't figure it out and i thought this would only be possible with a macro, however @RashedDS posted a perfect solution with no macros.
Congrats @RashedDS! and Thanks Patrick for this interesting puzzle!
My solution is very easy just working on 2 levels of rows as sum will be always the same