How to sum a total from multiple cell values submitted through a form?

lizette_1978

I am trying to create an expense form with multiple cell values and want to sum the total "expenses". When inserting a sum command, it changes the command to a text value, inserting an apostrophe in front of the command (this is being done in automation). How do I sum the total value of the claim once it is submitted through a form automatically?

Paul Newcome

You would have to insert the formula into the sheet directly and convert it to a column formula.