Sigma Squared
Lexington, KY, USA
614-973-9100
Follow on:
Linkedin-in Twitter Youtube

Month: May 2023

SUMX2PY2

  • May 31, 2023
Definition: The SUMX2PY2 function in Excel is used to find the sum of the sum of squares of two corresponding arrays. Syntax: ==SUMX2PY2(array_x, array_y). Situation: This formula is...
Read More

SUMX2MY2

  • May 31, 2023
Definition: The SUMX2MY2 function in Excel is used to find the sum of the difference between squares of two corresponding arrays. Syntax: ==SUMX2MY2(array_x, array_y). Situation: This formula is...
Read More

SUMSQ

  • May 31, 2023
Definition: The SUMSQ function in Excel is used to find the sum of the squares of a range of data. Syntax: ==SUMSQ(number1, [number2], ...). Situation: This formula is...
Read More

SUMPRODUCT

  • May 31, 2023
Definition: The SUMPRODUCT function in Excel is used to find the sum of the product of two or more arrays. Syntax: ==SUMPRODUCT(array1, [array2], ...). Situation: This formula is...
Read More

SUMIFS

  • May 31, 2023
Definition: The SUMIFS function in Excel is used to find the sum of a range of data that meets multiple specified criteria. Syntax: ==SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2],...
Read More

SUMIF

  • May 31, 2023
Definition: The SUMIF function in Excel is used to find the sum of a range of data that meets a specified criteria. Syntax: ==SUMIF(range, criteria, [sum_range]). Situation: This...
Read More

SUM

  • May 31, 2023
Definition: The SUM function in Excel is used to find the sum of a range of data. Syntax: ==SUM(number1, [number2], ...). Situation: This formula is appropriate in situations...
Read More

SUBTOTAL

  • May 31, 2023
Definition: The SUBTOTAL function in Excel is used to calculate a subtotal for a range of data using a specified function. Syntax: ==SUBTOTAL(function_num, range). Situation: This formula is...
Read More

SUBSTITUTE

  • May 31, 2023
Definition: The SUBSTITUTE function in Excel is used to replace a part of a text string with a different text string. Syntax: ==SUBSTITUTE(text, old_text, new_text, [instance_num]). Situation: This...
Read More

STEYX

  • May 31, 2023
Definition: The STEYX function in Excel is used to find the standard error of the predicted y-value for each x in the regression. Syntax: ==STEYX(known_y's, known_x's). Situation: This...
Read More