COUNT Posted on 17-01-2020 , by: admin , in Uncategorized , 0 Comments previous NEXT COUNT What Does It Do ? This function counts the number of numeric entries in a list. It will ignore blanks, text and errors. Syntax =COUNT(Range1,Range2,Range3… through to Range30) Formatting No special formatting is needed. Entries To Be Counted Count 10 20 30 3 =COUNT(C4:E4) 10 0 30 3 =COUNT(C5:E5) 10 -20 30 3 =COUNT(C6:E6) 10 ####### 30 3 =COUNT(C7:E7) 10 21:30 30 3 =COUNT(C8:E8) 10 0.26478 30 3 =COUNT(C9:E9) 10 30 2 =COUNT(C10:E10) 10 Hello 30 2 =COUNT(C11:E11) 10 #DIV/0! 30 2 =COUNT(C12:E12) Example: The following table was used by a builders merchant to calculate the number of sales for various products in each month. Item Jan Feb Mar Bricks £1,000 Wood £5,000 Glass £2,000 £1,000 Metal £1,000 Count 3 2 0 =COUNT(D29:D32) previous NEXT