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.


 
 


 
 
 
 
 
 




      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          • 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

          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ




                                ご検討中の方

                                  • Recent Topics

                                  • Ask the Expert – Zoho One Admin Track : une session dédiée aux administrateurs Zoho One

                                    Vous administrez Zoho One et vous vous posez des questions sur la configuration, la gestion des utilisateurs, la sécurité ou encore l’optimisation de votre back-office ? Bonne nouvelle : une session Ask the Expert – Zoho One Admin Track arrive bientôt,
                                  • How to Associate Zoho Projects in Zoho CRM

                                    Hi I need script for associating projects in zoho projects to particular Account in zoho CRM side. It can be done manually but I need the automation for this process. There are no api regarding associating a project in zoho crm account. Need assistance
                                  • Add Claude in Zoho Cliq

                                    Let’s add a real AI assistant powered by Claude to your workspace this week, that your team can chat with, ask questions, and act on conversations to run AI actions on. This guide walks you through exactly how, step by step, with all the code you'll need.
                                  • Create custom rollup summary fields in Zoho CRM

                                    Hello everyone, In Zoho CRM, rollup summary fields have been essential tools for summarizing data across related records and enabling users to gain quick insights without having to jump across modules. Previously, only predefined summary functions were
                                  • Need to set workflow or journey wait time (time delay) in minutes, not hours

                                    Minimum wait time for both Campaigns workflows and Marketing Automation journeys is one hour. I need one or the other to be set to several minutes (fraction of the hour). I tried to solve this by entering a fraction but the wait time data type is an integer
                                  • Editing Item Group to add Image

                                    I did not have the image of the product when the Item Group was created. Now I have the product image, and would like to associate/add to the Item Group. However the Item Group Edit functionality does not show/allow adding/changing image. Please hel
                                  • Composite Product (kit) - Dynamic Pricing

                                    I am setting up Composite Products for item kits that I sell. I also sell the items from the kit individually. Problem is when pricing changes on an individual part, the Composite Product price does not change meaning when the cost of item # 2 in the
                                  • Urgent: Slow Loading Issue on Zoho Commerce Website

                                    Dear Zoho Support Team, I am experiencing slow loading times on my Zoho Commerce website, which is affecting its performance and user experience. The issue persists across different devices and networks. Could you please investigate this matter and provide
                                  • Cliq Bots - Post message to a bot using the command line!

                                    If you had read our post on how to post a message to a channel in a simple one-line command, then this sure is a piece of cake for you guys! For those of you, who are reading this for the first time, don't worry! Just read on. This post is all about how
                                  • Zoho Books - France

                                    L’équipe de Zoho France reçoit régulièrement des questions sur la conformité de ses applications de finances (Zoho Books/ Zoho Invoice) pour le marché français. Voici quelques points pour clarifier la question : Zoho Books est un logiciel de comptabilité
                                  • Introducing Bigin's Add-in for Microsoft Outlook

                                    Hello Everyone, Email is an important way to communicate with customers and prospects. If you use Outlook.com for emails and Bigin as your CRM, the Outlook Add-in helps you connect them easily so you can see your Bigin contact details right inside Outlook.com.
                                  • New in Office Integrator: Download documents as password-protected PDFs

                                    Hi users, We're excited to introduce password-protected PDF as a download option in Zoho Office Integrator's document editor. This allows you to securely share your confidential information from within your web app. Highlights of the password-protected
                                  • Sales IQ - Zobot en multilangue

                                    Bonjour, J'ai un Zobot installé sur mon site depuis longtemps. J'ai ajouté plusieurs langues, dans la configuration et dans le générateur de bot sans code Pourtant, le Chat continue à s'afficher en Francais. Comment enclencher le multilangue en front
                                  • Streamlining E-commerce Photography with AI Background Tools

                                    Hey Zoho Community, I’ve been messing around with ways to make product images less of a headache for fashion brands on Zoho Commerce. You know how boring generic backdrops can get, and how much time traditional photoshoots eat up, right? I tried out this
                                  • Is there a way to show contact emails in the Account?

                                    I know I can see the emails I have sent and received on a Contact detail view, but I want to be able to see all the emails that have been sent and received between all an Accounts Contacts on the Account Detail view. That way when I see the Account detail
                                  • Android Solutions

                                    hi everyone, I’m in the process of evaluating Android Solutions for my organization. Despite exploring multiple resources, I haven’t been able to narrow down the options and feel quite overwhelmed. A colleague advised me to ask here, and I would sincerely
                                  • Add "Reset MFA" Option for Zoho Creator Client Portal Users

                                    Hello Zoho Creator Team, We hope you are doing well. We would like to request an important enhancement related to Multi-Factor Authentication (MFA) for client portal users in Zoho Creator. Currently, Creator allows us to enforce MFA for portal users,
                                  • 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
                                  • Collapsing and expanding of lists and paragraphs

                                    hello Would you ever implement Collapsing and expanding of lists and paragraphs in zoho writer ? Best regards
                                  • Saving issue

                                    First problem I opened a MS word file in writer. after the work is done, it does not save instantly, I waited for like 10min and it still did not save. second problem When I save a file, then file gets saved as another copy. I just did save, not save
                                  • Introducing Built-in Telephony in Zoho Recruit

                                    We’re excited to introduce Built-in Telephony in Zoho Recruit, designed to make recruiter–candidate communication faster, simpler, and fully traceable. These capabilities help you reduce app switching, handle inbound calls efficiently, and keep every
                                  • Does Zoho Writer have Dropdowns

                                    I want to add a drop down field in Zoho writer. Is this possible?
                                  • Fix image at bottom of a page fot automatic proposal creation

                                    I'm working on a proposal document to automate our proposal creation process. So far it works fine, but I experience some problems with an image I want to have fixed at the bottom of the page AND above the footer. This section of the document consists
                                  • Notifications Feeds unread count?

                                    How do I reset the unread count on feeds notifications?  I've opened every notification in the list.  And the count never goes to zero.
                                  • Tables for Europe Datacenter customers?

                                    It's been over a year now for the launch of Zoho Tables - and still not available für EU DC customers. When will it be available?
                                  • Zoho Finance Limitations 2.0 #3: Can't assign a Contact to a Finance Record (estimate, sales order or invoice)

                                    If you use a business to business scenario with different contact people within the company you can't assign a finance record (estimate, invoice, etc...) to that person. Why this matters? No way to find out which person placed the order without manual
                                  • Ranking by group in report

                                    Dears, I am new to Zoho Analytics and I would like to ask you guys help to creating a ranking column. Report type: Pivot Matter: I want to create a ranking column on the right of Percentage. This ranking is group by column Type, and ranking by Final Score/Percent.
                                  • Zoho CRM for Everyone's NextGen UI Gets an Upgrade

                                    Hello Everyone We've made improvements to Zoho CRM for Everyone's Nextgen UI. These changes are the result of valuable feedback from you where we’ve focused on improving usability, providing wider screen space, and making navigation smoother so everything
                                  • Zoho Community Digest — Febrero 2026

                                    ¡Hola, comunidad! Un mes más os traemos las novedades más interesantes de Zoho para febrero de 2026, incluyendo actualizaciones de producto publicadas oficialmente, cambios de políticas y noticias del ecosistema. Pero antes de lanzarnos a las actualizaciones,
                                  • Disable Zoho Contacts

                                    We don't want to use this app... How can we disable it?
                                  • Department Overview by Modified Time

                                    We are trying to create visuals to show the work our agents do in Zoho Desk. Using Zoho Analytics how can we create a Department Overview per modified time and not ticket created time? In order for us to get an accurate view of the work our agents are
                                  • Filter button in the Zoho Sheet Android App doesn't toggle on

                                    I am a new Zoho Sheets user and experiencing a specific issue with the filter functionality in the Android mobile application. Detailed Issue Description: The filter icon appears correctly in the toolbar. Upon tapping the filter icon/button, the toggle
                                  • Empty folders are now appearing in the sidebar...

                                    ...and the folder list is now auto-collapsed by default with no way to change. Neither of these recent updates are useful or user-friendly. ==================== Powered by Haiku https://www.haiku.co.uk ====================
                                  • 【Zoho CRM】商談タブへのデータインポート

                                    Zoho使用前にエクセルで管理していた商談情報を、Zoho一括管理のため、商談タブにインポートしたいのですが、お客さまの氏名だけが紐づけられませんでした。 「Zoho CRMにインポートする項目を関連付ける」のところが画像のようになっています。 (弊社では、「姓」を「★個人データ名」という項目名に変更し、フルネームを入れて使用しています。) どのようにしたら氏名をインポートできるかご存じの方がいらっしゃいましたら、ご教示いただきたく、よろしくお願いいたします。 (投稿先が間違っていましたらご指
                                  • CRM Cadences recognise auto-responses

                                    I have leads in a Cadence. I get an auto-responder reply "I'm out of the office..." Normally Cadences seems to know that isn't a real reply and keeps the lead enrolled in the cadence. However, today, Cadences has UNENROLLED a Lead who sent an auto-reponse
                                  • SalesIQ Chat Notifications

                                    I am the admin of our salesIQ implementation. About two weeks ago, I started hearing/seeing notification for ALL chats messages from monitored agents/chat participants. I don't need to see these, we have a manager who deals with this. I can't stop the
                                  • How to Create a Fixed Sliding Time Window (D-45 to D-15) in Zoho Analytics ?

                                    Hello, I would like to create a report in Zoho Analytics based on a sliding time window between D-45 and D-15, with a fixed snapshot of that specific period. The data displayed should strictly reflect activity recorded between D-45 and D-15 only, without
                                  • Export Zoho Books to another accounting package?

                                    Is an export feature to Quickbooks or Accpac available (or a form that is easily imported by them)?  My reasons: 1) my accountant, who prepares my corporate tax return, prefers to work with their own accounting system.  If I can convert Zoho books a form that is easily importable into Quickbooks or an Accpac format, this process would be easy. 2) I don't want to keep my data in a proprietary format on the cloud somewhere without a way to easily extract it to a format that can be read my a well established
                                  • Anchor Links in Dashboards

                                    Hello,  Our dashboards frequently have multiple sections that would be more easily skipped between using anchor links. Please consider adding an anchor link feature to the text widget? This could be done by adding an anchor link option to the text widget next to the "remove" option (see screenshot). The option would assign an ID to the <div> containing the text widget in the live dashboard. Then, the chosen ID could be linked using a traditional <a href="#link_id"> in the html section of the text
                                  • system not picking my default custom service report template

                                    Can you tell me why when we create a service report always pick the (standard old) template? Even when I have a custom service report selected as Default.
                                  • Next Page