Subtotal Columns in spreadsheet on forms

Is there a way to add the total for columns to a form on the page. I added spreadsheet to form and would like the last column to total all the columns amounts.

For example,

I want to add T-shirt total, Donation total and Registration Fee together and put the total in the total column (located to the right of the other columns)

Hi Kim,

Thanks for reaching out to Jotform Support. I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

We appreciate your patience while we work on a solution.

Thank you!

Hi Kim,

It's easy to add calculation on your Spreadsheet Widget. Let me show you how:

1. On your Form Builder, select the Spreadsheet widget and click on the wand icon to open the Widget Settings.
2. On the Widget Settings, under Default Values copy the formula below:

You can just change the row number on the formula for the other rows that you will need computation. See screencast below for the result:

Give it a try and let us know how it goes.