Studies show that good grammar leads to more promotions and higher salaries. Write with Grammarly

SUMSQ Function in Excel

In this post, let’s learn how the SUMSQ Function works in excel, describes the formula syntax, and how you can use the SUMSQ Function in your excel spreadsheet

What is SUMSQ Function in Excel? 

The SUMSQ Function in Excel is used to return the sum of the squares of the value provided. 

Syntax  

=SUMSQ (number 1, [number 2],…..) 

Parameter 

  • Number 1– (Required) The first argument or series of numbers that are to be squared and then summed up. 
  • Number 2– (Optional) The first argument or series of numbers that are to be squared and then summed up. 

Example 

=SUMSQ(A2:A9) 

=SUMSQ(5) 

How to use SUMSQ Function in Excel? 

The following steps will explain the work of the SUMSQ function in an excel spreadsheet:      

  • First, prepare an excel spreadsheet with the specified details in it, or open an existing Excel spreadsheet.   
  • To, perform SUMSQ Function, let us begin with the SUMSQ command following the “=” operator within the parenthesis to declare the argument of series. 
How to use SUMSQ Function in Excel? 

Note: 

  • Arguments may be a mixed match of constants, numbers, letters, arrays, and names.