Get total of all Grand Total fields in all forms into one Sheets using formula

I actually wanted the default values of Grand total of all sheets in an new column called Grand Total All 

Which is grand total 1+2+3+4+5= Grand Total All

Where in it shows all the grand total values and totals up

Else even if it totals up in original column of grand total is also fine

But I'm unable to place the formula

Thanks

I understand that you are getting the total of the Grand Total fields in all of your form's Sheets into one of your forms' Sheets.

That would be possible using Formula. You may need to connect each Grand Total field in the other forms to the Sheets you would like it to appear. In this case, each Grand Total field from the different forms will have its own column in the (main) Sheets.

After that, you will add the value of each Grand Total field column which data are from different forms into another column — Grand Total ALL using formula

Here's how the formula would look like.

Result:

Dear Mike,

Really appreciate your efforts for thr detailed illustration. I'm trying out the same

Thanks and regards 

Ravi

Do get back to us if you experience any inconvenience while setting this formula.

Thanks.