Need Help with SUM function

I have a software program that kicks out Excel reports with data from its fields and I need to add the cells up. I can put the =SUM(A1:D1) formula in a field within the software so it adds up A1 through D1 no problem but the simple =SUM(A1:D1) then shows up in row 2. So where it should be =SUM(A2:D2) Excel is taking the literall text in the field so it is not working beyond row 1. I get =SUM(A1:D1) in all rows.

My thinking is to come up with a formula that uses the ROW() function to tell the next cell down to use the proper formula so I'm trying =SUM(A(ROW()):D(ROW())) and it is not working. I think I'm on the right track but don't quite know the syntax.

Suggestions?

Thanks.