Shows you how to use the COUNTIF function in Microsoft Excel.

The MMULT function in Excel is used for matrix multiplication. It takes as inputs two arrays or matrices and outputs the matrix product of the two

The DAverage function in Excel is used to calculate the average of values in database based on entered criteria.  The format of the function is: =DAVERAGE(range, field, criteria) The range is the group of cells which you want to analyze and apply your criteria against. The field is the column …

The SUMPRODUCT function in Excel is a useful tool when you are working with large datasets or multiple arrays.

Learn to use the And Function in Excel.