Excel SUMPRODUCT function
The Excel SUMPRODUCT function multiplies an array by another array(s) and sums the results.
The Excel SUMPRODUCT function multiplies an array by another array(s) and sums the results.
The Excel ROUNDUP function returns a number rounded up to the specified number of digits.
The Excel ROUNDDOWN function returns a number rounded down to the specified number of digits.
The Excel ROUND function returns the rounded number of given number to the specified number of digits.
The MAX IF formula finds the maximum value from a range when a specific condition is met.
The Excel COUNTIFS function counts the number of occurrences of a condition or multiple conditions within a range of cells.
The Excel COUNTIF function counts the number of occurrences of a condition within a range of cells. The COUNTIF function is useful for quickly counting instances of data within a dataset.
The Excel SUMIFS function adds numerical values from a range of cells when certain condition(s) are true. The SUMIFS function is useful for summing specific subsets of data with one or more specific criteria.
The Excel SUMIF function adds numerical values from a range of cells when a condition is true. The SUMIF function is useful for summing specific subsets of data.
The Excel SUM function adds numerical values from user input, cells, and/or ranges. The SUM function is one of the most popular functions.