COUNTBLANK function

Use The COUNTBLANK function is the Statistical function, which is used to count the number of blank cells in a range of cells. Syntax =COUNTBLANK(range) where, (range) – The cell range from which you want to count the blank cells. Example 1- Type =COUNTBLANK in your desired cell and select cell range A4:A9.  2- Excel will count all […]

Count cells that contain [n] (e.g. five) characters

Use the COUNTIF function to count cells that contain [n] characters. In our example, we will count cells that contain five characters/ alphabets. Formula: The formula used above has following arguments: range (A5:A9) – The range of cells to count against the criteria. criteria (??????) – The criteria to sum only six alphabets. Result:  

Count cells that begin with

By using the COUNTIF function, we can count cells that begin with a specified criteria. In our example, we will count those cells that contain “RBC”. Formula: How the formula works The formula used above has following arguments: range (A5:A9) – The range of cells to count based on the criteria. criteria (“RBC*”) – The […]

Count cells that do not contain

Use the COUNTIF function, to count cells that do not contain specific text or number. In our example, we will count cell based on two criteria. Formula: How the formula works The formula used above has following arguments: range (A5:A9) – The range of cells to count based on the criteria. criteria (“<>*RB*”) – The […]

Count cells if contain positive numbers

The COUNTIF function is used to counts cells based on a single criterion. e.g. we can use the function to count cells if contain positive numbers. Formula: How the formula works The formula used has following arguments: range (B5:B9) – The range of cells to count based on the criteria. criteria (“>0”) – The criteria […]

Count cells if contain negative numbers

Use the COUNTIF function to count cells if contain negative numbers. Formula:   How the formula works The formula used above to count negative values has following arguments: range (B5:B9) – The range of cells to count based on the criteria. criteria “<0” – The criteria to count if cells contain negative values only. Result:

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