Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelSUMSQ Function in Excel

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.

Note:

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

Share:

You May Also Like

SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021