Suppose you want to multiply a column of numbers by the same number in another cell. The trick to multiplying a column of numbers by one number is adding $ symbols to that number's cell address in the formula before copying the formula. In our example table below, we want to multiply all the numbers in column A by the number 3 in cell C2.
Perform conditional calculations on ranges of cells. Sum based on multiple criteria with SUMIFS.
The MMULT function returns the matrix product or multiplication of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. The way you enter the formula depends on which version of Office 365 you are using.
You can use arrays that evaluate as True or False (1 or 0) as criteria by using them as factors (multiplying them by the other arrays). For example, suppose you want to calculate net sales for a particular sales agent by subtracting expenses from gross sales, as in this example.