Excel spreadsheet and Input table

  • Profile Image
    Asked on June 25, 2020 at 09:20 AM

    I have the Excel spreadsheet in my report. 


    Can you help me with calculations? I need to put both column B and column D totals into the Total $ field and make that a bold and larger font and all those input values should be $ format?

    Also in the form, I have an input table below. I need to calculate both input tables values into Grand Total? Is that possible. If you can help that would be great.
  • Profile Image
    Answered on June 25, 2020 at 01:33 PM

    To get the total of the columns, you can use the formula b22= b1 + b2 + d1 + d2  until all the fields in the column are added.


    Sample screenshot:


    Regarding the format, it is not possible to add a dollar sign inside the sheets column with the calculation.

    To clarify, do you want to change the fields labels font size or the input?

    Looking forward for your response.