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. […]

Count cells that are blank

Use the COUNTBLANK function to count cells that are blank. In our example, the formula used is: =COUNTBLANK(A4:A9) where, (A4:A9) – The cell range from which you want to count the blank cells. Example Formula: Result: How to count non-empty cells? Use the COUNTA function to count non-empty cells from a selected range. Formula: Result:

COUNTA function in Excel

Use The COUNTA function counts the total number of cells that are not empty in a selected range. Description The function counts cells that include e.g. numbers, text, error values, and, logical values. In our example, we will count six cells containing different values. Syntax =COUNTA(value1, [value2], …) The COUNTA function has following arguments: value1 […]

Count items from a list

To count items from a list or table, you can use the COUNTIFS function. In our example, the formula used is: =COUNTIFS(A5:A9,”B”,B5:B9,”5″) How the formula works The formula has following arguments: criteria_range1 (A5:A9)- The range of cells to count based on criteria1. criteria1 (“B”) –  The criteria, to count party B only in range1 criteria_range2 (B5:B9) – The […]

COUNTIFS function

Use The COUNTIFS function counts the number of cells based on single or multiple criteria. In our example, we will count cells with number values greater than 30 and smaller than 50. Syntax =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) where, criteria_range1 (A4:A9)- The range of cells to count based on criteria1. criteria1 (“>30”) –  The criteria, to count greater […]

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved