Minimum Value

Use Returns with the minimum value. Description by using the MIN function, we can find the minimum value in a set of values. In our example, the formula used in D5 is: =MIN(A5,B5,C5) where, number1 (A5) – The required argument for which you want to find minimum value. [number2] (B5) & [number3] (C5) – The 2nd & […]

Larger of two values

Use Returns the largest value. Description To get the larger of two values, use the MAX function. In our example, the formula used is: =MAX(A5,B5) where, A5 and B5 are cell references, being used against the argument of number1 and [number2]. You can add upto 255 numbers for which you want the maximum value. Example Formula: […]

Calculate average that ignores zero

We can calculate the average that ignores zero in the selected range of cell by using the AVERAGEIF function. In our example, we will calculate the average by adding and ignoring zero and see how results change significantly. Example Formula: Result: How the formula works The formula used =AVERAGEIF(A6:C6,”<>0″) has following arguments: range (A6:C6) – […]

Weighted Average

By using the combination of the SUMPRODUCT function and the SUM function, we can calculate the weighted average for a set of numbers. Follow these steps to calculate the weighted average: 1– Type =SUMPRODUCT in cell B12, select the cell range B5:B9 against array1 argument and C5:C9 against [array2] argument of the function.  2– Add slash […]

Average top 3 numbers

For an average of top 3 numbers, use the combination of the AVERAGE function and the LARGE function. Follow these steps to do so: 1– Go to F5 cell, type “=AVERAGE”. 2– Type “LARGE” and select the LARGE function by pressing the tab button. 3– Excel will create options against the LARGE function. 4– Select cells […]

Count Functions

Count blank cells only To count blank cells only, use the COUNTBLANK function. In our example, we have only two blank cells. Count cells that are not empty Use the COUNTA function to count cells that are not empty. Formula: Result: Count To count cells from the selected range of cells, use the COUNT function. […]

Copyright © 2016 - 2017 | All Rights Reserved