Formula generating #n/a at last row after formula being dragged down.

I have this formula that was created by another user that worked out great for one version of the data.

I have now modified the way the data appears and to my luck the formula almost works but it is generating a #N/A at the end.

This is the formula used in my first version which works perfectly but not on my second version.
=IF(AND(A19<>0,A19<>"other"),SUM(INDIRECT("c"& ROW(C19) & ":c" & MATCH(TRUE,INDEX(A20:A$100<>"other",0),0)+ROW(A18))),"")

Please see the attached workbook.

Ideally, I would like to keep the formula style the same since many other formulas used the same style.