Skip to main content
Mitratech Success Center
Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

How to Insert a Formula on Report Exported Excel File .

  1. Last updated
  2. Save as PDF

How to Insert a Formula on Report Exported Excel File?

Follow the below steps to insert a formula in the report exported as an Excel file:

You can only insert a formula to get the sum of all the entries in a certain column once the values in this column are converted as numbers. 

  • Once the report has been exported as an Excel file, make sure that editing is enabled. Scroll to the column where you want to add a formula.

clipboard_efbee6fa968c1e8fa58037f3bf3c33ac3.png 

  • Highlight the entries that are needed for the formula.

clipboard_e978656ab3588e98412dacf8928a3521d.png 

  • Once the entries are highlighted, click on the 'i' icon and click on 'Convert to Number'.

clipboard_eafc4e6782e8aa5429b903ab84a380b8d.png 

  • Since the entry values have met the requirement, you can now add/ create a formula in Excel for the said column/entries.

clipboard_e6a6b051736032bae1f53b0e0e6c8ff4e.png