-
Microsoft Excel Office 365
Learn How to Use Microsoft Excel SUMSQ Function
In this article, you will learn how to use the Microsoft Excel SUMSQ function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel SUMSQ function return value and syntax with the help of some examples.
Microsoft Excel SUMSQ Function
The main function of the Microsoft Excel SUMSQ function is to get the squares of provided values. That implies, with the help of the SUMSQ function you can able to get the squares of values provided by you. It should be noted that the values that you provided can be in the form of constants, cell references, or ranges. Also keep in mind Empty cells, logical values, and text values are ignored when they appear in arrays or references. The logical values TRUE and FALSE are evaluated as 1 and 0 respectively, but only when they are hardcoded as arguments. Numbers entered as text that is "1", "3", etc., are evaluated, but only when they are hardcoded as arguments. So, with the help of the SUMSQ function, you can able to get the squares of provided values.
Return Value of SUMSQ Function
The return value will be the calculated sum of squares of values provided.
Syntax of SUMSQ Function
=SUMSQ(number1, [number2], ...)
Where the arguments:
- number1: This is the first argument or number containing numeric values.
- number2: This is the second argument or number containing numeric values (optional).
How to Use Microsoft Excel SUMSQ Function?
So we know that Microsoft Excel SUMSQ function you can able to get the squares of provided values. That implies, with the help of the SUMSQ function you can able to get the squares of values provided by you. It should be noted that the values that you provided can be in the form of constants, cell references, or ranges. So, with the help of the SUMSQ function, you can able to get the squares of provided values.
Check out the list of all other articles:
- Learn How to Get nth Match in Microsoft Excel
- Learn How to Find Missing Values in Microsoft Excel
- Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
- Learn How to Sort by Text Length in Microsoft Excel
- Learn How to Sort by Two Columns in Microsoft Excel
- Learn How to Sort by Random in Microsoft Excel
- Learn How to Sort by One Column in Microsoft Excel
- Learn How to Sort by Custom List in Microsoft Excel
Comments