Sunday, 23 April 2017

Excel - Microsoft Excel Sqrtpi Function

Description

The Excel SQRTPI function returns the square root of a supplied number multiplied by p. 
I.e. 

SQRTPI( number ) = SQRT( number * p ) 

The syntax of the Sqrtpi function is :

SQRTPI( number ) 

Where the number argument is a positive numeric value, to multiply by pi, before calculating the square root. 

Sqrtpi Function Examples
The following spreadsheet shows four examples of the sqrtpi function. 

The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right. 


Sqrtpi Function Errors
If you get an error from the Excel Sqrtpi Function, this is likely to be one of the following: 

Common Errors 

Excel - Microsoft Excel Sumproduct Function

Description


The Excel Sumproduct function returns the sum of the products of the corresponding values in two or more supplied arrays.

The format of the function is: 

SUMPRODUCT( array1, array2, [array3], ... ) 

where the array arguments are arrays of numeric values, which may be supplied to the function directly, or as one or more cells or ranges of cells containing numeric values. All of the supplied arrays must be of equal length and non-numeric values in the supplied arrays are treated as the value zero. 


In Excel 2007 and Excel 2010, you can provide up to 255 arrays to the function, but in Excel 2003, you can only provide up to 30 arrays. 

The spreadsheets on the right show 3 examples of the Sumproduct function. 
The format of the functions are shown in the top spreadsheet and the resulting values are shown in the spreadsheet below. 

Note that: 

Sumproduct Function Error
If you get an error from the Excel Sumproduct Function, this is likely to be the #VALUE! error: 

Common Error 

Excel - Microsoft Excel Sumsq Function

Description

The Excel Sumsq function returns the sum of squares of a supplied set of values. 
The format of the function is: 

SUMSQ( number1, [number2], ... ) 

where the number arguments are numeric values or arrays of values. These can be supplied to the function either directly, as values returned from other formulas, or as references to cells containing numeric values. 


If the values supplied to the function are text values, or logical values, these will be handled as follows: 

In Excel 2007 and Excel 2010, you can provide up to 255 number arguments to the function, but 
In Excel 2003, you can only provide up to 30 number arguments. 

Sumsq Function Examples
The spreadsheet below shows examples of the Sumsq function. 
The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right. 

The above examples show how the arguments to the function can be input as an array, or as multiple values, and how the arguments can be input both directly and as references to cells containing values. 

Sumsq Function Error
Although the Sumsq function is able to interpret logical values and text representations of numbers that are supplied directly to the function, as numbers, and will ignore text or logical values that are supplied via a cell reference, you may occasionally get the #VALUE! error returned from the function: 

Common Error 













Excel - Microsoft Excel Sumx2my2 Function

Description

The Excel Sumx2my2 function returns the sum of the differences of squares of two supplied sets of values. I.e. 

where the array arguments are two sets of numeric values, which may be supplied to the function either directly, or as one or more cells or ranges of cells containing numeric values. These two supplied arrays must be of equal length. 

Note that, if any of the values supplied to the functions are non-numeric (including cells containing text representations of numbers), these values, and the corresponding value in the other array are ignored. 

The spreadsheets on the right show 2 examples of the Sumx2my2 function. 
The format of the functions are shown in the top spreadsheet and the resulting values are shown in the spreadsheet below. 

Note that the example in cell C3 shows that the array arguments can be supplied directly to the function, as well as in the form of arrays of cells 


Sumx2my2 Function Error
If you get an error from the Excel Sumx2my2 Function, this is likely to be the #N/A error: 

Common Error 


Excel - Microsoft Excel Sumx2py2 Function

Description

The Excel Sumx2py2 function returns the sum of the sum of squares of two supplied sets of values. I.e. 
where the array arguments are two sets of numeric values, which may be supplied to the function either directly, or as one or more cells or ranges of cells containing numeric values. These two supplied arrays must be of equal length. 

Note that, if any of the values supplied to the functions are non-numeric (including cells containing text representations of numbers), these values, and the corresponding value in the other array are ignored. 

The spreadsheets on the right show 2 examples of the Sumx2py2 function. 
The format of the functions are shown in the top spreadsheet and the resulting values are shown in the spreadsheet below. 

Note that the example in cell C3 shows that the array arguments can be supplied directly to the function, as well as in the form of arrays of cells 


Sumx2py2 Function Error
If you get an error from the Excel Sumx2py2 Function, this is likely to be the #N/A error: 

Common Error 

Excel - Microsoft Excel Sumxmy2 Function

Description

The Excel Sumxmy2 function returns the sum of the squares of differences between corresponding values in two supplied arrays. I.e. 

where the array arguments are two sets of numeric values, which may be supplied to the function either directly, or as one or more cells or ranges of cells containing numeric values. These two supplied arrays must be of equal length. 

Note that, if any of the values supplied to the functions are non-numeric (including cells containing text representations of numbers), these values, and the corresponding value in the other array are ignored. 


The spreadsheets on the right show 2 examples of the Sumxmy2 function. 
The format of the functions are shown in the top spreadsheet and the resulting values are shown in the spreadsheet below. 

Note that the example in cell C3 shows that the array arguments can be supplied directly to the function, as well as in the form of arrays of cells 


Sumxmy2 Function Error
If you get an error from the Excel Sumxmy2 Function, this is likely to be the #N/A error: 

Common Error 

Excel - Microsoft Excel Sumxmy2 Function

Description

The Excel Sumxmy2 function returns the sum of the squares of differences between corresponding values in two supplied arrays. I.e. 
where the array arguments are two sets of numeric values, which may be supplied to the function either directly, or as one or more cells or ranges of cells containing numeric values. These two supplied arrays must be of equal length. 

Note that, if any of the values supplied to the functions are non-numeric (including cells containing text representations of numbers), these values, and the corresponding value in the other array are ignored. 


The spreadsheets on the right show 2 examples of the Sumxmy2 function. 
The format of the functions are shown in the top spreadsheet and the resulting values are shown in the spreadsheet below. 

Note that the example in cell C3 shows that the array arguments can be supplied directly to the function, as well as in the form of arrays of cells 


Sumxmy2 Function Error
If you get an error from the Excel Sumxmy2 Function, this is likely to be the #N/A error:

Common Error