What is SUM?

respectSign
This is a recommends products dialog
Top Suggestions
Starting at
View All >
Language
French
English
LangEntry.ChineseTaiwan
ไทย
LangEntry.Dutch
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 >
spend
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
Temporarilyunavailable
Discontinued
comingsoon
minicart_error_please_view
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 SUM?

SUM is a function used in computing and programming to add together numbers in a sequence. This function can be applied in various programming languages such as Python, Java, structured query language (SQL), and more. It's a staple tool for data analysis, helping you to quickly calculate totals.

Can I use SUM with non-numerical data?

No, you can't use the SUM function with non-numerical data directly. The SUM function is designed to work with numerical values. However, in some programming languages, you can convert the non-numerical data into numerical data before using the SUM function.

Does SUM always need a range of values?

Not necessarily. While the SUM function is often used with a range of values, it can also operate on individual numbers in many programming languages. The function will simply return the sum of the numbers you provide.

Could I use SUM in a database query?

Absolutely, in fact, using the SUM function in a database query is quite common. For instance, in structured query language (SQL), you could use the SUM function to calculate the total sales, the total number of items sold, or any other numerical data stored in your database.

Would SUM be able to handle negative numbers?

Yes, the SUM function can handle negative numbers. If you have a sequence that includes positive and negative numbers, the function will correctly calculate the total, considering the negative values.

What happens if I use SUM with an empty list or array?

If you use the SUM function with an empty list or array, the result would usually be zero. This is because there are no numbers to add together. However, the exact behavior might vary depending on the specific programming language you're using.

When should I use the SUM function?

You should use the SUM function whenever you need to add together a series of numbers. This could be when you're calculating totals, averages, or carrying out other types of data analysis. It's a versatile function that can be used in a wide range of scenarios.

What if I want to find the sum of a series in Python?

In Python, you can use the built-in sum () function to add together a series of numbers. You simply pass the list or array of numbers as an argument to the function, like this: sum ([1, 2, 3, 4, 5]).

Does the SUM function work with floating-point numbers?

Yes, the SUM function works with floating-point numbers. It will correctly add together the numbers, considering the fractional parts. However, keep in mind that due to the way floating-point numbers are represented in computers, the result might not be exact.

Can I use SUM with complex numbers in Python?

Yes, in Python, you can use the sum () function with complex numbers. The function will correctly add together the real and imaginary parts separately. For example, sum ([1+2j, 3+4j]) would return 4+6j.

Could I use the SUM function in other programming languages like JavaScript?

Yes, you can use the concept of a SUM function in JavaScript, but it's not as straightforward as in some other languages. In JavaScript, you'd typically use the reduce () method to calculate the sum of an array of numbers.

What about using SUM in excel?

The SUM function is one of the most used in Excel. You can use it to add together a range of cells, individual cells separated by commas, or even a mix of both. It's a powerful tool for data analysis in spreadsheets.

Does the SUM function work with boolean values?

In some programming languages, yes. For instance, in Python and JavaScript, Boolean values are treated as 0 for False and 1 for True when used in arithmetic operations. So, using the SUM function with Boolean values in these languages would give you the count of True values.

Can I use the SUM function in structured query language (SQL) to find the average?

While the SUM function itself doesn't calculate averages, it can be used as part of the process. To find the average in SQL, you would sum up the values using the SUM function and then divide them by the count of the values, which can be found using the COUNT function.

Can I use the SUM function to add together the elements of a matrix?

Yes, in many programming languages, you can use the SUM function (or an equivalent) to add together the elements of a matrix. However, the process might involve flattening the matrix into a single list or array of numbers first.

Does using the SUM function have any impact on performance?

Using the SUM function is generally quite efficient, but it can have an impact on performance if you're dealing with a very large amount of data. However, in most cases, the impact would be negligible compared to the time it would take to manually add together the numbers.

Can the SUM function be used with strings?

In some programming languages, you can use the SUM function (or an equivalent) to concatenate strings. However, in many cases, there are more appropriate functions for this purpose, such as JOIN in Python or CONCATENATE in Excel.

What's the difference between SUM and SUMPRODUCT in excel?

The SUM function in Excel simply adds together a range of cells. On the other hand, the SUMPRODUCT function multiplies arrays of numbers together and then sums the result. This makes it a powerful tool for more complex calculations.

Can I use the SUM function to add together the elements of multiple arrays?

Yes, you can use the SUM function to add together the elements of multiple arrays in many programming languages. However, the exact process will depend on the language. For instance, in Python, you might use a combination of the sum() function and list comprehension.

Can the SUM function be used with dates?

In some cases, yes. For example, in Excel, you can use the SUM function to add together a range of cells that contain dates. However, keep in mind that this will give you the sum of the date serial numbers, not a meaningful sum of the dates themselves.

Can I use the SUM function in a recursive function?

Yes, you can use the SUM function within a recursive function in many programming languages. This could be useful for things like calculating the sum of all the numbers in a data structure with an unknown or variable size.

What's the difference between SUM and COUNT in structured query language (SQL)?

The SUM function in SQL adds together a range of values, while the COUNT function simply counts the number of rows that match a specified condition. So, SUM would give you the total of a set of numbers, while COUNT would give you the number of items in the set.

{"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  ()
x