Tip #20: Work with numbers easily using Table formulas in Writer

Tip #20: Work with numbers easily using Table formulas in Writer

Whether you're drafting a numerical table to calculate the total number of students in class or combining multiple mathematical functions to arrive at the quarterly profits, Table Formulas in Writer let you solve simple mathematical calculations by inserting formulas into cells.



For instance, say you’ve chronologically jotted down the distance you travelled in the previous week to send it to your company’s Payroll team to collect reimbursements. Instead of manually calculating the total distance travelled, you can add formulas to let Writer calculate it for you. 

To add formulas inside the table follow the below steps:

1. Click the cell where you want to add the formula.

 
2. Click the Formula icon near the inserted table to open the formula window. 


3. The Formula Settings will open. Now enter the formula you want to use. Since we want the total of the distances, we would choose the SUM formula. You can also prefix or suffix values to the result for better clarity. Since the distance is calculated in miles, we've entered the value as Miles.



4. Now click OK. The result will be as shown below.




5. If you want the sum of only certain cells, you can get the desired result by specifying the cell numbers. So if you want the sum of only the distance travelled between Monday and Thursday, you'd specify the cell numbers from B2 and B5 as shown below.


 
So you would get the sum from cells B2 to B5 as shown below.
 



6. Similarly, you can add other functions according to your need.
​
 

 
7. Writer also lets you format results, from rounding-off to formatting decimal places. So regardless of the data format, you can use table formulas to have custom formats in the results. So if the table cells all have numbers with two decimals, you can round off the result to have 0 decimals as shown below.

To do this, go to Formula Settings, and select 0 from the Number Format drop down. Similarly, you can choose other number formats of your choice as well. 




Click here to learn more about using Table Formulas. 



Happy writing!




Found this helpful? Subscribe to  Writer Community  for more tips and tricks.


 
 


 
 
 
 
 
 





      • Sticky Posts

      • 8 Neat Tricks in Writer You Should Know About

        Want to get the most out of Writer and speed up your work? You've come to the right place. We've compiled some productive shortcuts in Writer that can help you get work done more quickly: 1. Look up synonyms   No more need for a bulky thesaurus! Use Writer's synonym suggestions to explore different word choices, and find the one that fits your style and tone the best. All you have to do is right-click on a word, and select Synonyms from the dropdown list.  2. Insert images, tables and more   Typing

      • Tip #26: Filter your records before merging a document

        Tom is an HR executive who has to send onboarding emails every month to newly joined employees. He has a master spreadsheet with all the employee details, and new employees are added to them as they join. It's the month of March and Tom has to send onboarding emails to employees who've joined this month. But, how is Tom going to go through a big spreadsheet with multiple new and past information, and send onboarding emails to the set of newly joined employees?     Simple, by filtering and merging

      • Tip: #11 Collaboratively fill documents with your colleagues and clients

        Last week we talked about how Fillable Fields can help you create contracts and proposal templates you can repurpose across your processes. This week, we'll talk in detail about how to collaboratively fill those templates with your clients and team.    Say you've entered into a contract with multiple clients but the final contract amount is still under negotiation. Using fillable fields, partners can quote their contract fee directly in the template document without affecting other areas of the document. You

      • Tip #07: Five best defaults in Writer you can change to complement the way you work

        Find yourself adjusting settings to the way you like every time you create a new document? Try tweaking the default settings instead.  From font styles to auto correct options and more, here are the five best defaults settings you can control.   1. Default font style   Use your favorite typography across all your documents. You can customize a font style by adding a color, adjusting its size and more, and then set it as default.    To do this, go to More Options > Format > Font. Choose a font style

      • Tip #06: Make the best use of Zia in Writer

        About to share your work with your team? Looking to get a second opinion quickly before that? Let Zia do it.    Zia, Zoho's AI-powered intelligent assistant is now part of Writer. She's trained to check and polish your work. She doesn't just read, she understands. So apart from grammar and spelling checks, she'll let you know when you've used a wrong adjective, or have missed out words based on the context of your piece.   Every time you write, Zia makes a scorecard after carefully assessing your

        • Recent Topics

        • Problem Adding Facebook Account

          Hi, I'm new here, I'm having trouble setting up my Facebook account as a social channel. I think the issue is down to how my Facebook is set up, which is pretty confusing. I have a personal Facebook account (let’s called it A) which is my main Facebook

        • Zoho Desk Teams App is not loading

          Hi Zoho Desk support. Need an assistance on the Zoho Desk Teams app. Once I click View Ticket, it isn't showing anything. Kindly refer to attached: ZohoDesk Teams App_View Ticket Error.jpg For our Dashboard, we are still experiencing the same issue. Kindly

        • About Meetings (Events module)

          I was working on an automation to cancel appointments in zoho flow , and in our case, we're using the Meetings module (which is called Events in API terms). But while working with it, I'm wondering what information I can display in the image where the

        • Zoho People - Retrieve the Leave Details - get("LeaveCount")

          Hi, Zoho People I need to collect all of an employee's leave requests for the calendar year and check how many half-days they have taken. If I run the script on the query he just modified, I can retrieve the information related to that query and use the

        • Mapping a new Ticket in Zoho Desk to an Account or Deal in Zoho CRM manually

          Is there any way for me to map an existing ticket in Zoho desk to an account or Deal within Zoho CRM? Sometimes people use different email to put in a ticket than the one that we have in the CRM, but it's still the same person. We would like to be able

        • Which WhatsApp API works seamlessly with Zoho CRM?

          I’m exploring WhatsApp API solutions that integrate seamlessly with Zoho CRM for customer communication, lead nurturing, and automation. I would love to hear insights from those who have successfully implemented WhatsApp within Zoho CRM. My Requirements:

        • Allow people to sign a zoho form by using esign or scanned signature

          Allow people to sign a zoho form by using esign or scanned signature

        • Button to Reapply Filters on Sheet(s)

          I wrote a macro that I attached to a button to reapply the filters on all my sheets and it says it works, but it doesn't actually do anything. What is wrong with it? Is there another way? Or even make it work for one sheet? Sub UniversalFilterRefresh()

        • Integrate Multiple ZohoBooks organization with zoho projects

          We have successfully connected our Zoho Books with Zoho Projects for synronizing timesheet data. Our Business specialty is, that the staff of the Main company (A) is working on several projects, but the Clients are sometimes contracted and paying to a

        • Zoho OAuth Connector Deprecation and Its Impact on Zoho Desk

          Hello everyone, Zoho believes in continuously refining its integrations to uphold the highest standards of security, reliability, and compliance. As part of this ongoing improvement, the Zoho OAuth default connector will be deprecated for all Zoho services

        • Flexible Partial-Use Coupons (Stored Value Credits)

          Subject: Feature Request: Ability for users to apply partial coupon balances per transaction Problem Statement Currently, our coupons are "one-and-done." If a user has a $50 coupon but only spends $30, they either lose the remaining $20 or are forced

        • Unable to Assign Multiple Categories to a Single Product in Zoho Commerce

          Hello Zoho Commerce Support Team, I am facing an issue while assigning categories to products in Zoho Commerce. I want to assign multiple categories to a single product, but in the Item edit page, the Category field allows selecting only one category

        • How do I add todays date to merge field

          I don't see any selection of todays date when creating a letter. Surely the date option of printing is standard? John

        • Add RTL and Hebrew Support for Candidate Portal (and Other Zoho Recruit Portals)

          Dear Zoho Recruit Team, I hope you're doing well. We would like to request the ability to set the Candidate Portal to be Right-to-Left (RTL) and in Hebrew, similar to the existing functionality for the Career Site. Currently, when we set the Career Site

        • Tracking Emails sent through Outlook

          All of our sales team have their Outlook 365 accounts setup with IMAP integration. We're trying to track their email activity that occurs outside the CRM. I can see the email exchanges between the sales people and the clients in the contact module. But

        • Whats that

          Price?

        • The same Contact associated to multiple Companies - Deals

          Hi, I would like to know if there is an option to associate the same contact with multiple companies (two or more) deals, using the same contact details for all. This is because we have contacts who are linked to different companies or branches of the

        • Convert invoice from zoho to xml with all details

          How to convert an Invoice to XML format with all details

        • Portals-Adjust Column Sizes

          I am trying to adjust the column widths in Portals tabs. Columns that don't need to be wide are wide and longer ones are very short. I thought adding more to the digits box in Edit would widen them, but it doesn't. Anyone know how to adjust these?

        • Add link/button to open approved record from approval list and detail views?

          Hi, How do I allow users to click on an approval record and open that submission? For example, userA submits a quotation then userB approves/rejects. They both can see the quotation on "completed task" list & detail views, but there's no way for them

        • record submitted from creator and invoice is creating in books , but the workflow of books is not tiggering on create of record in books

          record submitted from creator and invoice is creating in books , but the workflow of books is not tiggering on create of record in books headermap = Map(); headermap.put("X-ZOHO-Execute-CustomFunction","true"); response_inv = invokeurl [ url :"https://www.zohoapis.com/books/v3/invoices/fromsalesorder?salesorder_id="

        • Prevent editing of a record after getting approved/rejectedr

          Hi, I'd like to block any user from editing a record after it was approved or rejected, how can I do that?

        • Formula Field/Campo de Fórmula

          Hello everyone, I have a purchase requisition form in which each department submits a request, and the request is automatically routed to the person responsible for that department. In this form, I have several fields with the following link names: Quantidade1,

        • Free Webinar: Zoho Sign for Zoho Projects: Automate tasks and approvals with e-signatures

          Hi there! Handling multiple projects at once? Zoho Projects is your solution for automated and streamlined project management, and with the Zoho Sign extension, you can sign, send, and manage digital paperwork directly from your project workspace. Join

        • Formatting Problem | Export to Zoho Sheet View

          When I export data to Zoho Sheet View, ID columns are automatically formatted as scientific notation. Reformatting them to text changes the actual ID values. For example, 6557000335603071 becomes 6557000335603070. I have attached screenshots showing this

        • Introducing Workqueue: your all-in-one view to manage daily work

          Hello all, We’re excited to introduce a major productivity boost to your CRM experience: Workqueue, a dynamic, all-in-one workspace that brings every important sales activity, approval, and follow-up right to your fingertips. What is Workqueue? Sales

        • Feature Request - The Ability to Link A Customer with a Vendor

          Hi Finance Suite Team, Many businesses buy and sell products from the same companies or individuals. For example, a car sales business may buy a car from a member of the public, and that member of the public may also buy a new car from us. This makes

        • Long table name (sync from Zoho Creator)

          Dears, How can I remove the suffix in parentheses? These tables are synced from Zoho Creator and are treated as system tables, so their names cannot be changed. This issue makes the aggregation formulas look awful.

        • [Free Webinar] Learning Table Series - Streamlining incident management process with Zoho Creator

          Hello everyone, We’re excited to invite you to another edition of the Learning Table Series webinar. As you may already know, we've moved to a purpose-based approach in the Learning Table Series this year. Each session now focuses on how a Zoho Creator

        • Unattended - Silent

          How can I hide the tray icon / pop up window during unattended remote access for silent unattended remote access?

        • Importing into Multiselect Picklist

          Hi, We just completed a trade show and one of the bits of information we collect is tool style. The application supplied by the show set this up as individual questions. For example, if the customer used Thick Turret and Trumpf style but not Thin Turret,

        • Text snippet

          There is a nice feature in Zoho Desk called Text Snippet. It allows you to insert a bit of text anywhere in a reply that you are typing. That would be nice to have that option in Zoho CRM as well when we compose an email. Moderation Update: We agree that

        • Marketing Tip #18: Make your online store mobile-friendly to improve traffic

          Most online shoppers browse on their phones first. If your store is hard to read, slow to load, or tricky to navigate on mobile, they’ll bounce fast. A mobile-friendly store doesn’t just look nice; it improves engagement, reduces drop-offs, and helps

        • [Need help] Form closed. Please contact your form administrator for further assistance.

          https://forms.zohopublic.com/cceinfoifly1/form/CCE2025CCEFocusGroupRegistrationForm2025Fall/formperma/s_8XcLETTbFxZ_TAS4r_W6W5UBl8o5oxEnIX35IBKg4 I checked we didn't exceed the usage limit and form availability is enabled, Please help us enable this form

        • Zoho People. Updating TabularData

          I am trying to update tabular data in the record. I always have the same response. I have checked many times. Section ID is correct. May be something wrong with request structure itself. Can someone help me. Body content type: form urlencoded query params

        • Automatically CC an address using Zoho CRM Email Templates

          Hi all - have searched but can't see a definitive answer. We have built multiple email templates in CRM. Every time we send this we want it to CC a particular address (the same address for every email sent) so that it populates the reply back into our

        • Unable to Send Different Email Templates for Different Documents in Zoho Sign

          Hello Zoho Community, I am facing a limitation with Zoho Sign regarding email notifications sent to customers when a document is sent for signing. Currently, whenever I send any template/document for signing, the email notification that goes to the customer

        • Reminder needs 0 minute choice

          I most use 0 minute reminders.  Every other calender service has this choice.  If I create an event in my Android calendar with 0 minute reminder it will change to 5 minute.  Please ad 0 as a reminder choice, this should be a 5 minute fix.  Thanks.

        • Customer ticket creation via Microsoft Teams

          Hi all, I'm looking to see if someone could point me in the right direction. I'd love to make it so my customers/ end users can make tickets, see responses and respond within microsoft teams. As Admin and an Agent i've installed the zoho assist app within

        • Is there a way to update all the start and end dates of tasks of a project after a calendar change?

          Hi! Here's my situation. I've built a complete project planning. All its tasks have start dates and due dates. After completing the planning, I've realized that the project calendar was not the right one. So I changed the project calendar. I now have

        • Next Page