Tag: count in excel

Count function count how many numeric value are available in a selected range. If selected range is A2:B8 and if any cell contains text or it contain numeric value together with text or the cell is empty then the Count function will ignore all that in selected range and will count the cells that only contains the pure numeric value.. You Can also select the different range by giving separate reference . PARAMETER: =COUNT ( Value1, Value2 , Value3 ) ...... FORMULA = COUNT ( A2 : B4 , A5,:B8)