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

  • Profile Image
    Asked on March 25, 2020 at 02:29 PM

    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


  • Profile Image
    Answered on March 25, 2020 at 03:06 PM

    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.




  • Profile Image
    Answered on March 28, 2020 at 04:51 AM

    Dear Mike,

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

    Thanks and regards 


  • Profile Image
    Answered on March 28, 2020 at 10:07 AM

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