Moving Right When Dragging Formula Down

INDEX function makes this easy to do. Let's assume that you don't want to reference any columns further left than column Z (adjust as required) and that the start cell for the first formula is A2 (adjust as required) then you can use this formula in A2 copied down

=SUMIF(INDEX($B$2:$Z$5758,0,ROWS(A$2:A2)),">1",N$2:N$5758)

INDEX with zero as the row reference returns the whole column, the specific column is determined by ROWS function which increments by 1 each row as you copy down so moves one column to the right each time.

INDEX is normally preferable to any solution using OFFSET or INDIRECT because those two functions are volatile - meaning that the formula re-calculates every time anything in the worksheet is re-calculated

You can try something like this It adjusts the column value based upon the row position, but you can adapt it to your starting position in A2

=SUMIF(INDIRECT(ADDRESS(2,ROW()+1)&":"&ADDRESS(5758,ROW()+1)),">1",$N$2:$N$5758)

If column N needs adjusting also for the sumif do the same with that in A3

=SUMIF(INDIRECT(ADDRESS(2,ROW()+1)&":"&ADDRESS(5758,ROW()+1)),">1",INDIRECT(ADDRESS(2,ROW()+12)&":"&ADDRESS(5758,ROW()+12)))