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.

 

 

 

 

 

 

 

 

• Topic Participants

• Rhema R

• Abhimanyu

• Shaun Jude O Brien

• 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

• Ability to assign Invoice Ownership through Deluge in FSM

  Hi, As part of our process, when a service appointment is completed, we automated the creation of the invoice based on a specific business logic using Deluge. When we do that, the "Owner" of the invoice in Zoho FSM is defaulted to the SuperAdmin. This

• Import Error: Empty values for mandatory fields - Closing Date

  Hello,  I've tried multiple times to import a CVS Potential list from another Zoho account. But the error message I get is:  Empty values for mandatory fields - Closing Date There are valid dates in this field, so I don't understand why this error messages comes up, and it won't import. It's in the format Zoho exports CVS files in, so it should not have any problems reading it.. any suggestions?  Thanks!

• Easily perform calculations using dates with the new DATEDIF function

  Hey Zoho Writer users! We've enhanced Zoho Writer's formula capabilities with the new DATEDIF function. This allows you to calculate the difference between dates in days, months, and years. Function syntax: =DATEDIF(start_date, end_date, unit) Inputs:

• Adding Comments Using Workflows - How to Change User Attributed

  We have worklflows in Desk where a comment is added to a ticket based on certain criteria. It seems that the comment added is always attributed to the user who last edited the workflow. This does not make sense for us because: - It's misleading to other

• Add Attachment Support to Zoho Flow Mailhook / Email Trigger Module

  Dear Zoho Support Team, We hope you are well. We would like to kindly request a feature enhancement for the Mailhook module in Zoho Flow. Currently, the email trigger in Zoho Flow provides access to the message body, subject, from address, and to address,

• Conect chat of salesiq with zoho cliq

  Is there any way to answer from zoho cliq  the chat of salesiq initiated by customers?

• Les dernières avancées en saisie de données et collaboration

  Après une année dédiée à la recherche et au développement, notre équipe est prête à dévoiler des améliorations majeures pour Zoho Sheet. Ces nouveautés seront lancées par étapes afin d’en assurer une prise en main optimale. Nous commençons avec des fonctionnalités

• Deluge Learning Series – Client functions in Deluge | January 2026

  We’re excited to kick-start the first session of the 2026 Deluge Learning Series (DLS) with Client functions in Deluge. For those who are new to DLS, here’s a quick overview of what the series is all about: The Deluge Learning Series takes place on the

• Rich Text For Notes in Zoho CRM

  Hello everyone, As you know, notes are essential for recording information and ensuring smooth communication across your records. With our latest update, you can now use Rich Text formatting to organize and structure your notes more efficiently. By using

• display call description in the notes section of a contact or add notes field to completed call screen

  When completing a call, we type in the result of the call in the description. However, that does not show up under the notes history on the contact. We want to be able to see all the calls that have taken place for a contact wihtout having to go into each completed call. The other option is to add the notes field to the completed call screen.

• Implement Meeting Polls in Zoho Bookings

  Dear Zoho Bookings Support Team, We'd like to propose a feature enhancement related to appointment scheduling within Zoho Bookings. Current Functionality: Zoho Bookings excels at streamlining individual appointment scheduling. Users can set availability

• Zoho Bookings and Survey Integration through Flow

  I am trying to set up flows where once an appointment is marked as completed in Zoho Bookings, the applicable survey form would be sent to the customer. Problem is, I cannot customise flows wherein if Consultation A is completed, Survey Form A would be

• Service Account Admin for API Calls and System Actions

  Hello, I would like to request the addition of a Service Account Admin option in Zoho product. This feature would allow API calls and system actions to be performed on behalf of the system, rather than an active user. Current Issue: At present, API calls

• How to apply customized Zoho Crm Home Page to all users?

  I have tried to study manuals and play with Zoho CRM but haven't found a way how to apply customized Zoho CRM Home Page as a (default) home page for other CRM users.. How that can be done, if possible? - kipi Moderation Update: Currently, each user has

• Please can the open tasks be shown in each customer account at the top.

  Hi there This has happened before, where the open tasks are no longer visible at the top of the page for each customer in the CRM. They have gone missing previously and were reinstated when I asked so I think it's just after an update that this feature

• How to Customize Task Creation to Send a Custom Alert Using JavaScript in Zoho CRM?

  Hello Zoho CRM Community, I’m looking to customize Zoho CRM to send a custom alert whenever a task is created. I understand that Zoho CRM supports client scripts using JavaScript, and I would like to leverage this feature to implement the alert functionality.

• Send Whatsapp with API including custom placeholders

  Is is possible to initiate a session on whatsapp IM channel with a template that includes params (placeholders) that are passed on the API call? This is very usefull to send a Utility message for a transactional notification including an order number

• Configurable Zoho Cliq Notifications for Zoho People Alerts

  Hello Zoho People Product Team, Greetings and hope you are doing well. We would like to request an enhancement to Zoho People notifications, enabling a native delivery via Zoho Cliq with admin-level control, similar to the notification settings available

• Add Israel & Jewish Holidays to Zoho People Holidays Gallery

  Greetings, We hope you are doing well. We are writing to request an enhancement to the Holidays Gallery in Zoho People. Currently, there are several holidays available, but none for Israel and none for Jewish holidays (which are not necessarily the same

• Keep Zoho People Feature Requests in the Zoho People Forum

  Hello Zoho People Product Team, Greetings. We would like to submit a feature request regarding the handling of feature requests themselves, specifically for Zoho People. Issue: Feature Requests Being Moved to Zoho One Zoho People feature requests are

• ZO25: The refreshed, more unified, and intelligent OS for business

  Hello all, Greetings from Zoho One! 2025 has been a remarkable year, packed with new features that will take your Zoho One experience to the next level! From sleek, customizable dashboards to an all-new action panel for instant task management, we’ve

• Introducing Multi-Asset Support in Work Orders, Estimates, and Service Appointments

  We’re excited to announce a highly requested enhancement in Zoho FSM — you can now associate multiple assets with Work Orders, Estimates, and Service Appointments. This update brings more clarity, flexibility, and control to your field service operations,

• [Product Update] Locations module migration in Zoho Books integration with Zoho Analytics

  Dear Customers, As Zoho Books are starting to support an advance version of the Branches/Warehouses module called the Locations module, users who choose to migrate to the Locations module in Zoho Books will also be migrated in Zoho Analytics-Zoho Books

• Introducing Schedules for smarter availability management

  Greetings from the Zoho Bookings team! We’re excited to introduce Schedules, a powerful enhancement to manage availability across your workspace. Schedules are reusable working-hour templates that help you define and maintain consistent availability across

• Why Zoho Contracts Prefers Structured Approvals Over Ad-hoc Approvals

  Approvals are one of the most important stages in a contract’s lifecycle. They determine whether a contract moves forward, gets revised, or needs further discussion. The approval process also defines accountability within the organization. Zoho Contracts

• Whatsapp Connection Status still "Pending" after migration

  Hello, I migrated my WhatsApp API to Zoho from another provider a day ago. So far the connection status is still “Pending”. There is a problem? How long does it usually take?

• Kaizen #226: Using ZRC in Client Script

  Hello everyone! Welcome to another week of Kaizen. In today's post, lets see what is ZRC (Zoho Request Client) and how we can use ZRC methods in Client Script to get inputs from a Salesperson and update the Lead status with a single button click. In this

• Search Bar positioning

  Why is the Search bar on the far right when everything is oriented towards the left?

• How to use Rollup Summary in a Formula Field?

  I created a Rollup Summary (Decimal) field in my module, and it shows values correctly. When I try to reference it in a Formula Field (e.g. ${Deals.Partners_Requested} - ${Deals.Partners_Paid}), I get the error that the field can’t be found. Is it possible

• How to Filter timewise question to check uploaded one month or two months before in these community question ?

  i want to find the question that is asked some month or before any particular year, so how can i filter it ?

• Proposal for Creating a Unique "Address" Entity in Zoho FSM

  The "Address" entity is one of the most critical components for a service-oriented company. While homeowners may change and servicing companies may vary, the address itself remains constant. This constancy is essential for subsequent services, as it provides

• Workflow Down/Bug

  We have a workflow that sends an email to one of our internal departments 10 minutes after a record is created in a custom module. The workflow actually works correctly. However, we have now noticed that on January 8, between 3:55 p.m. and 4:33 p.m.,

• Service Locations: Designed for Shared Sites and Changing Customers

  Managing service addresses sounds simple—until it isn’t. Large facilities, shared sites, and frequently changing customers can quickly turn address management into an operational bottleneck. This is where Service Locations deliver clarity and control.

• Can I re-send the Customer Satisfaction Survey after a ticket closure?

  Hello, Some customers does not answer the survey right after closure, is it possible to re-send after a few days or weeks? Best Regards!

• Filter contacts based on selected category in Zoho Desk ticket

  Hello community, I’m setting up the Tickets module in Zoho Desk and I need help implementing the following: When a category is selected in a ticket, I want the Contact field to be filtered so that it only displays contacts that are related to that category.

• 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

• Assign Income to Project Without Invoice

  Hello, Fairly new user here so apologies if there is a really obvious solution here that I am just missing... I have hundreds of small deposits into a bank account that I want to assign to a project but do not want to have to create an invoice every time

• Tracking Non-Inventory Items

  We have several business locations and currently use zoho inventory to track retail items (sales and purchase orders). We were hoping to use zoho inventory to track our non-inventory items as well (toilet paper, paper towels, etc). I understand that we

• Profile Page View Customization

  I need to change the fields, sections from the profile view of an emplyoyee.

• Zoho Desk Android app update: Filter, Sort and Saved filters Enhancements

  Hello everyone! We are excited to introduce the below features on the Android version Zoho Desk mobile app: 1. Filter & Sort support has been introduced for the Contacts and Accounts modules. 2. Sort options is now available in Custom Modules as well.

• Next Page