I see option to calculate total of the columns but not row.. I don't have access to sharepoint designer well.. is there anyway to do it through front-end..
Assuming you have
Field3 - all numeric.
To have a
Field4 that sums a row, use calculated column with
To have a pseudo-row that sums a column, modify the view to enable totals. This will not work with calculated columns.
Update view and use the total option to sum the values in a column.
In order to make a workflow I would recommend downloading sharepoint designer. Then load up the site you are trying to change and create a list workflow for the list you are trying to manipulate. Use workflow variables in a looping structure to loop through the columns in the row and sum the totals.