Forum Discussion
Solved
Excel Formula to sum the above value
Ok this is my dummy data. There is three column Column A Funded amount, Column B Payment amount, AND Column C is difference amount which i want. Now there are some conditions and points. F...
=IF(A2=0,0,A2-SUM(INDEX($B$2:$B$100,IFERROR(LARGE(IF($A$2:A2<>0,ROW($A$2:A2)-1),2),1)):INDEX($B$2:$B$100,ROW()-2)))
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
=IF(A2=0,0,A2-SUM(INDEX($B$2:$B$100,IFERROR(LARGE(IF($A$2:A2<>0,ROW($A$2:A2)-1),2),1)):INDEX($B$2:$B$100,ROW()-2)))
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
Hey Pawn Thanks alottt I got the my answer. But this formula is little bit confusing for me can you please elaborate the working of this formula I really want to know how it works. If you can then please otherwise no worry but thanks for the help sir.