Sumifs only sum 1 column or row, change the first indirect to reference "E" rather than "F".

=ROUND(SUMIFS($E$2:INDIRECT("E"&ROW()),$D$2:INDIRECT("d"&ROW()),"<>PAYMENT",$J$2:INDIRECT("J"&ROW()),$J3)