--- title: Quick Totals Without Formulas description: Easily get sums, averages, or counts in Excel by simply highlighting your data and checking the Status Bar no formulas needed. image: https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/The%20image%20features%20a%20computer%20screen%20displaying%20an%20open%20Excel%20spreadsheet%20filled%20with%20numerical%20data%20in%20various%20cells%20At%20the%20bottom%20right%20corner%20of%20th.png --- [![logo](https://woodthorpeitsolutions.co.uk/hubfs/logo.png)](https://woodthorpeitsolutions.co.uk) - [Home](https://woodthorpeitsolutions.co.uk) - [Private Course](https://woodthorpeitsolutions.co.uk/private-courses) - [Public Course](https://woodthorpeitsolutions.co.uk/public-course-dates) - [Tips](https://woodthorpeitsolutions.co.uk/tips-and-news) - [Contact us](https://woodthorpeitsolutions.co.uk/contact) - [Home](https://woodthorpeitsolutions.co.uk) - [Private Course](https://woodthorpeitsolutions.co.uk/private-courses) - [Public Course](https://woodthorpeitsolutions.co.uk/public-course-dates) - [Tips](https://woodthorpeitsolutions.co.uk/tips-and-news) - [Contact us](https://woodthorpeitsolutions.co.uk/contact) [0800 044 3779](tel://08000443779) [Excel](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/excel) # Quick Totals Without Formulas [Woodthorpe IT](https://woodthorpeitsolutions.co.uk/tips-and-news/author/woodthorpe-it) 02 December, 2025 ![](https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/The%20image%20features%20a%20computer%20screen%20displaying%20an%20open%20Excel%20spreadsheet%20filled%20with%20numerical%20data%20in%20various%20cells%20At%20the%20bottom%20right%20corner%20of%20th.png) Need a quick sum, average, or count from your data  without any hassle?  - Just highlight your numbers. - Look at the **bottom right corner** of Excel’s window (the Status Bar) - it shows totals instantly, without typing a single formula. Example below: ![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/image-png-Oct-23-2025-01-04-05-6734-PM.png?width=712&height=352&name=image-png-Oct-23-2025-01-04-05-6734-PM.png) 👉 Right-click the Status Bar to choose what stats you’d like to see. Previous Post ###### [Quickly Format your data as a table](https://woodthorpeitsolutions.co.uk/tips-and-news/quickly-format-your-data-as-a-table) Next Post ###### [Clean Up Messy Text Fast](https://woodthorpeitsolutions.co.uk/tips-and-news/clean-up-messy-text-fast) ### Similar Blog Posts [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/missing%20information%20cartoon%20spreadsheet-1.jpeg?width=352&name=missing%20information%20cartoon%20spreadsheet-1.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/highlight-all-blank-cells-in-an-excel-list-quickly) #### [Highlight all blank cells in an Excel list quickly](https://woodthorpeitsolutions.co.uk/tips-and-news/highlight-all-blank-cells-in-an-excel-list-quickly) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/Happy%20person%20sitting%20Infront%20of%20a%20computer%20and%20looking%20relaxed%20cartoon-1.jpeg?width=352&name=Happy%20person%20sitting%20Infront%20of%20a%20computer%20and%20looking%20relaxed%20cartoon-1.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/drag-and-drop-in-outlook-you-have-the-power) #### [Drag and drop in Outlook - You have the power...](https://woodthorpeitsolutions.co.uk/tips-and-news/drag-and-drop-in-outlook-you-have-the-power) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/calendar%20maths%20cartoon.jpeg?width=352&name=calendar%20maths%20cartoon.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/the-final-countdown-date-maths-in-excel) #### [The final countdown (Date Maths in Excel)](https://woodthorpeitsolutions.co.uk/tips-and-news/the-final-countdown-date-maths-in-excel) [![Logo 290x70 - white](https://woodthorpeitsolutions.co.uk/hubfs/Logo%20290x70%20-%20white.png)](https://woodthorpeitsolutions.co.uk) Woodthorpe IT Solutions are providers of Microsoft 365 training and consultancy.  Established in 2005 we have trained over 10k people and continue to help learners get the most from their computer. [Want to resell our courses?  Click here to learn more.](https://woodthorpeitsolutions.co.uk/reseller) [Follow us on LinkedIn](https://www.linkedin.com/company/woodthorpe-it-solutions/) [Follow us on YouTube](https://www.youtube.com/@WoodthorpeITSolutionsLtdBlacon) ###### Get In Touch 0800 044 3779 contactus@woodthorpeit.com ##### Company details Co number: 05572129 Vat number: 936 2824 09 ##### Trust [Privacy Notice](https://woodthorpeitsolutions.co.uk/privacy-notice) [Terms](https://woodthorpeitsolutions.co.uk/terms) [Slavery and Human Trafficking Statement](https://woodthorpeitsolutions.co.uk/slavery-and-human-trafficking-statement) Copyright © 2026 Woodthorpe IT Solutions Limited ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Woodthorpe IT", "url" : "https://woodthorpeitsolutions.co.uk/tips-and-news/author/woodthorpe-it" }, "dateModified" : "2025-12-02T11:00:00.669Z", "datePublished" : "2025-12-02T11:00:00.000Z", "headline" : "Quick Totals Without Formulas", "image" : [ "https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/The%20image%20features%20a%20computer%20screen%20displaying%20an%20open%20Excel%20spreadsheet%20filled%20with%20numerical%20data%20in%20various%20cells%20At%20the%20bottom%20right%20corner%20of%20th.png" ], "mainEntityOfPage" : { "@id" : "https://woodthorpeitsolutions.co.uk/tips-and-news/quick-totals-without-formulas", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject" } } } ```