What is AutoSum?

This is a recommends products dialog
Top Suggestions
Starting at
View All >
Language
French
English
ไทย
German
繁體中文
Country
Hi
All
Sign In / Create Account
language Selector,${0} is Selected
Register & Shop at Lenovo Pro
Register at Education Store
Pro Tier Benefits
• Save up to an extra 20% on Think everyday pricing.
• Spend $15K, advance for FREE to Plus Tier with increased benefits.
Plus Tier Benefits
• Save up to an extra 25% on Think everyday pricing.
• Spend $50K, advance for FREE to Elite Tier with increased benefits.
Elite Tier Benefits
• Save up to an extra 30% on Think everyday pricing.
Reseller Benefits
• Access to Lenovo's full product portfolio
• Configure and Purchase at prices better than Lenovo.com
View All Details >
more to reach
PRO Plus
PRO Elite
Congratulations, you have reached Elite Status!
Pro for Business
Delete icon Remove icon Add icon Reload icon
TEMPORARILY UNAVAILABLE
DISCONTINUED
Temporary Unavailable
Cooming Soon!
. Additional units will be charged at the non-eCoupon price. Purchase additional now
We're sorry, the maximum quantity you are able to buy at this amazing eCoupon price is
Sign in or Create an Account to Save Your Cart!
Sign in or Create an Account to Join Rewards
View Cart
Your cart is empty! Don’t miss out on the latest products and savings — find your next favorite laptop, PC, or accessory today.
Remove
item(s) in cart
Some items in your cart are no longer available. Please visit cart for more details.
has been deleted
Please review your cart as items have changed.
of
Contains Add-ons
Subtotal
Proceed to Checkout
Yes
No
Popular Searches
What are you looking for today ?
Quick Links
Recent Searches
Hamburger Menu
skip to main content
{"backgroundColor":"#e6f4fa","sideMsg":"","data":[{"pcInfo":{"t_id":"","language":{},"id":""},"mAndTabInfo":"","bannerInfo":{"t_id":"Page94ee33f7-be68-4e3a-b027-f6548057899e","language":{"en_au":"%3Cp%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3ENeed%20Help%3F%26nbsp%3B%3C%2Fspan%3E%3Ca%20target%3D%22_self%22%20href%3D%22tel%3A13%20LENOVO%20%2F%2013%20536686%22%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(41%2C%2078%2C%20149)%3B%22%3ECall%20us%20on%2013%20LENOVO%20%2F%2013%20536686%3C%2Fa%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%26nbsp%3Bor%26nbsp%3B%3C%2Fspan%3E%3Ca%20target%3D%22_self%22%20href%3D%22https%3A%2F%2Finside.chat%2FLenovoAU%22%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(41%2C%2078%2C%20149)%3B%22%3Echat%20with%20us%3C%2Fa%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%26nbsp%3Bfor%20order%20related%20help%20and%20access%20to%20special%20deals!%3C%2Fspan%3E%3C%2Fp%3E","en":""},"id":"Page94ee33f7-be68-4e3a-b027-f6548057899e"},"gInfo":{"t_id":"","language":{},"id":""}},{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Page3e63dbd2-63e6-49c3-8b4c-201c5d971e40","language":{"en_au":"%3Cp%3E%3Cimg%20src%3D%22https%3A%2F%2Fp2-ofp.static.pub%2FShareResource%2Fanz%2Fimg%2FMasthead_Carousel%2Flfs-logo--reversed.svg%22%20alt%3D%22logo%22%20width%3D%2290%22%20height%3D%2218%22%20style%3D%22text-wrap%3A%20wrap%3B%22%2F%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%26nbsp%3B24%20months%20Interest%20Free*%20with%20Latitude.%20Call%2013%20LENOVO%2F%2013%20536686%20or%20chat%20with%20us%20to%20place%20an%20order.%26nbsp%3B%3C%2Fspan%3E%3Ca%20target%3D%22_self%22%20style%3D%22text-wrap%3A%20wrap%3B%20text-decoration-line%3A%20underline%3B%20color%3A%20rgb(41%2C%2078%2C%20149)%3B%22%3ECHAT%20NOW%20TO%20ORDER%3C%2Fa%3E%3C%2Fp%3E","en":""},"id":"Page3e63dbd2-63e6-49c3-8b4c-201c5d971e40"},"gInfo":""},{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Paged56756f3-3589-40bc-b752-63a3a890e518","language":{"en_au":"%3Cp%3E%3Cimg%20src%3D%22https%3A%2F%2Fp3-ofp.static.pub%2Ffes%2Fcms%2F2022%2F09%2F20%2Fsgy8gw8u4tymopd8g2224x0drocvbb133978.png%22%20alt%3D%22zip-logo%22%20style%3D%22text-wrap%3A%20wrap%3B%22%2F%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%26nbsp%3B17%20months%20interest%20free*%20with%20ZIP.%20Call%2013%20LENOVO%2F%2013%20536686%20or%20chat%20with%20us%20to%20place%20an%20order.%26nbsp%3B%3Ca%20target%3D%22_self%22%20style%3D%22text-decoration-line%3A%20underline%3B%20color%3A%20rgb(41%2C%2078%2C%20149)%3B%22%3ECHAT%20NOW%20TO%20ORDER%3C%2Fa%3E%3C%2Fspan%3E%3C%2Fp%3E","en":""},"id":"Paged56756f3-3589-40bc-b752-63a3a890e518"},"gInfo":""},{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Pagebe06910a-f31e-4fa7-8a56-bee24cf85016","language":{"en_au":"%3Cp%3E%3Cimg%20src%3D%22https%3A%2F%2Fp4-ofp.static.pub%2FShareResource%2FJPResource%2FJP-Images%2Fworkstations-px%2Famazonmusic-unlimited-horizontal-black.png%22%20alt%3D%22Amazon%20Music%20Unlimited%22%20width%3D%22130%22%20style%3D%22text-wrap%3A%20wrap%3B%22%2F%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3E%26nbsp%3BGet%204%20months%20Free.%20%2412.99%2Fmonth%20after.%20New%20subscribers%20only.%20Terms%20apply.%26nbsp%3B%3C%2Fspan%3E%3Ca%20href%3D%22%2Fp%2Faccessories-and-software%2Fsoftware-subscription%2Famazon-subscription%2Frr00125299%3FipromoID%3Dau_pc_carousel_banner_amu%22%20target%3D%22_blank%22%20textvalue%3D%22LEARN%20MORE%22%20style%3D%22color%3A%20rgb(79%2C%20129%2C%20189)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cspan%20style%3D%22color%3A%20rgb(79%2C%20129%2C%20189)%3B%22%3ELEARN%20MORE%3C%2Fspan%3E%3C%2Fa%3E%3C%2Fp%3E","en":""},"id":"Pagebe06910a-f31e-4fa7-8a56-bee24cf85016"},"gInfo":""},{"pcInfo":"","mAndTabInfo":"","bannerInfo":{"t_id":"Page6ec00a73-b892-4293-8895-1e323f513ee4","language":{"en_au":"%3Cp%3E%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%22%3EYoga%20Slim%207%20AI%20PC%20%7C%20Level%20up%20your%20creativity%20with%20next-gen%20AI%20experiences%20on%20the%20new%20Lenovo%20Yoga%20Slim%207x.%26nbsp%3B%20%3Cspan%20style%3D%22text-wrap%3A%20wrap%3B%20color%3A%20rgb(79%2C%20129%2C%20189)%3B%22%3E%26nbsp%3B%3C%2Fspan%3E%3C%2Fspan%3E%3Ca%20href%3D%22%2Fp%2Flaptops%2Fyoga%2Fai-pc-series%2Fyoga-slim-7x-gen-9-(14-inch-snapdragon)%2Flen101y0049%3FipromoID%3Dhellobar_au_04_AI_PC%22%20target%3D%22_self%22%20textvalue%3D%22Shop%20Now%22%20style%3D%22color%3A%20rgb(79%2C%20129%2C%20189)%3B%20text-decoration%3A%20underline%3B%22%3E%3Cstrong%3E%3Cspan%20style%3D%22color%3A%20rgb(79%2C%20129%2C%20189)%3B%22%3EShop%20Now%3C%2Fspan%3E%3C%2Fstrong%3E%3C%2Fa%3E%3C%2Fp%3E","en":""},"id":"Page6ec00a73-b892-4293-8895-1e323f513ee4"},"gInfo":""}],"autoRun":true,"displayTerminal":"pc,tablet,mobile"}

What is AutoSum?

AutoSum is a feature in Microsoft Excel spreadsheet software that allows you to quickly and automatically calculate the sum of a range of numbers. It eliminates the need for manual data entry and calculation, saving you time and effort. With AutoSum, you can easily add up a column or row of numbers with just a few clicks.

How do I use AutoSum in Microsoft Excel?

To use AutoSum in Microsoft Excel, first select the cell where you want the sum to appear. Then, click on the AutoSum button (Σ) located in the Home tab of the ribbon. Excel will automatically detect the range of adjacent cells containing numbers and suggest a sum formula. Press Enter to apply the formula and display the calculated sum in the selected cell.

Can AutoSum handle non-adjacent cells?

Yes, AutoSum can handle non-adjacent cells. Simply select the cells you want to include in the sum while holding down the Ctrl key. Excel will automatically adjust the formula to include the selected cells. This flexibility allows you to perform calculations on multiple ranges within the worksheet without the need for complex formulas.

What other functions are available in AutoSum?

In addition to summing values, AutoSum provides quick access to various other common functions. By clicking on the drop-down arrow next to the AutoSum button, you can choose functions like Average, Count, Max, Min, and more. This feature makes it convenient to perform a variety of calculations without having to manually type the formulas.

Can I customize the AutoSum function?

Yes, you can customize the AutoSum function to suit your specific needs. After clicking on the AutoSum button, you can modify the suggested formula by adding or removing cell references, applying logical operators, or including additional functions. This flexibility allows you to tailor the AutoSum feature to perform more complex calculations based on your requirements.

Does AutoSum work in other spreadsheet software?

While AutoSum is a specific feature in Microsoft Excel, similar functionality can be found in other popular spreadsheet software programs. For example, Google Sheets offers a similar feature called "Sum" in the toolbar, which allows you to automatically calculate the sum of selected cells. The availability and location of such features may vary across different spreadsheet applications.

Can I use AutoSum in Google Sheets?

Yes, Google Sheets provides a similar function to AutoSum called "Sum." To use it, select the cell where you want the sum to appear, then click on the "Sum" button located in the toolbar. Google Sheets will automatically detect adjacent cells containing numbers and suggest a sum formula. Press Enter to apply the formula and display the calculated sum in the selected cell.

Are there any shortcuts for using AutoSum?

Yes, there are shortcuts available for using AutoSum in both Microsoft Excel and Google Sheets. In Excel, you can press Alt + Equals (=) on your keyboard to quickly insert the AutoSum function into the selected cell. Similarly, in Google Sheets, you can press Ctrl + Shift + Plus (+) to achieve the same result. These shortcuts help streamline the process of performing calculations using AutoSum.

Can AutoSum handle ranges with empty cells?

When using AutoSum, if your range contains empty cells, the feature will automatically exclude those cells from the calculation. Only the non-empty cells within the selected range will be considered for summation. This ensures accurate and reliable calculations even when dealing with datasets that contain gaps or missing values.

How can I undo an AutoSum calculation?

If you want to undo an AutoSum calculation, simply select the cell with the calculated sum, press Ctrl + Z on your keyboard, or click on the Undo button in the toolbar. This action will revert the cell back to its original state before the AutoSum function was applied. It's a convenient way to correct mistakes or undo unwanted calculations.

Can I use AutoSum in formulas with conditions?

Yes, you can use AutoSum in formulas with conditions by employing functions like SUMIF or SUMIFS. These functions allow you to specify criteria for including or excluding values in the summation. By combining AutoSum with conditional logic, you can perform more advanced calculations and obtain results based on specific criteria or conditions within your dataset.

Can AutoSum handle large datasets?

Yes, AutoSum is designed to handle large datasets efficiently. Whether you have hundreds or thousands of rows or columns of data, AutoSum can quickly calculate the sum without any noticeable slowdown. The performance of AutoSum may depend on the processing power of your computer and the amount of available memory, but in general, it is capable of handling substantial amounts of data.

Can AutoSum be used in different worksheets or workbooks?

Yes, AutoSum can be used in different worksheets or workbooks within spreadsheet software. When selecting the range for AutoSum, you can switch between different worksheets or open workbooks to include cells from multiple locations. This capability allows you to perform calculations across different sheets or files without the need for manual data transfer or complex formulas.

Does AutoSum update automatically when new data is added?

Yes, AutoSum updates automatically when new data is added to the range. If you insert or delete rows or columns within the selected range, AutoSum will adjust the formula accordingly to include the updated data. This dynamic behavior ensures that the calculated sum remains up to date, eliminating the need to manually update the formula whenever changes occur in the dataset.

Can I use AutoSum with filtered data?

Yes, AutoSum can be used with filtered data. If you have applied filters to your dataset, AutoSum will automatically adjust the formula to include only the visible cell after the filtering is applied. This allows you to perform calculations on the filtered subset of data without the need to manually adjust the range or modify the formula.

Can AutoSum be used in conditional formatting?

While AutoSum itself cannot be directly used in conditional formatting, you can combine AutoSum with conditional formatting rules to highlight certain values based on specific criteria. By applying conditional formatting to the cell containing the AutoSum result, you can visually represent the data based on custom conditions or thresholds, making it easier to identify trends or outliers within the calculated sum.

Can I use AutoSum on a mobile device?

Yes, you can use AutoSum on a mobile device by accessing spreadsheet applications that support the feature. Microsoft Excel and Google Sheets both offer mobile versions that allow you to perform calculations using AutoSum on your smartphone or tablet. The functionality may be slightly different due to the constraints of the mobile interface, but AutoSum remains accessible and useful on mobile devices.

Does AutoSum work with negative numbers?

Yes, AutoSum works seamlessly with negative numbers. When you use AutoSum on a range that includes negative values, it accurately calculates the sum by considering the sign of each number. Whether you are dealing with a mix of positives and negatives or exclusively negative numbers, AutoSum ensures the total reflects the true sum. This feature is particularly useful in financial analyses, budgeting, and accounting tasks where expenses or losses are represented as negative values.

{"pageComponentDataId":"e857fdeft7e51-4b61-84dc-bccec6e68e00","pageComponentId":"e857fdeft7e51-4b61-84dc-bccec6e68e00","isAssociatedRelease":"true","pageComponentDataLangCode":"en_au","configData":{"jumpType":"currentTab","headlineColor":"black","displayNumber":"","styleMode":"vertical","miniCardHoMode":"2","headline":"","products":[{"number":{"t_id":"21kccto1wwau5","language":{"en_nz":"21kccto1wwau5","en_au":"21kccto1wwau5","en":""},"id":"Pageb33ce4b8-4839-4ba3-b993-7296d68a91b8"}},{"number":{"t_id":"21mccto1wwau3","language":{"en_nz":"21mccto1wwau3","en_au":"21mccto1wwau3","en":""},"id":"Page1fa61927-074c-4fe0-a8df-5c94362fb75c"}},{"number":{"t_id":"21lkcto1wwau3","language":{"en_nz":"21lkcto1wwau3","en_au":"21lkcto1wwau3","en":""},"id":"Pageca014688-410e-439a-a4c6-bba2ef6d4715"}},{"number":{"t_id":"21g2cto1wwau3","language":{"en_nz":"21g2cto1wwau3","en_au":"21g2cto1wwau3","en":""},"id":"Page79cd32c8-d467-4d68-b955-d273bb24eda7"}}]},"urlPrefix":"AAAAAAAH","title":"glossary-right-blue-boxes-fragment","pageId":"65b55929-de05-417a-a92a-ccb888d329b0","urlEdit":0,"uri":"/FragmentDirectory/glossary/glossary-right-blue-boxes-fragment.frag","pageComponentUuid":"e857fdeft7e51-4b61-84dc-bccec6e68e00"}
coming coming
Starting at
List Price
Web Price
Web Price:
List Price
Web Price
List Price is Lenovo’s estimate of product value based on the industry data, including the prices at which first and third-party retailers and etailers have offered or valued the same or comparable products. Third-party reseller data may not be based on actual sales.
Web Price is Lenovo’s estimate of product value based on industry data, including the prices at which Lenovo and/or third-party retailers and e-tailers have offered or valued the same or comparable products. Third-party data may not be based on actual sales.
Learn More
See More
See Less
View {0} Model
View {0} Models
Part Number:
Features
See More
See Less
Compare
Added!
Great choice!
You may compare up to 4 products per product category (laptops, desktops, etc). Please de-select one to add another.
View Your Comparisons
Add To Cart
Add To Cart
We're sorry,
Products are temporarily unavailable.
Continue shopping
Learn More
Coming Soon
Featured Product
Top Deals of the Day
Oops! No results found. Visit the categories above to find your product.
Save
open in new tab
© 2024 Lenovo. All rights reserved.
© {year} Lenovo. All rights reserved.
Compare  ()
removeAll x