Ask the Community
Ask any professional question and get answers from other specialists.
EMT based&combat medics
Example of Values in range are: . |921 | RED |44 | ABC | GREEN |467 | PINK |9 | (BLANK CELL) | ORANGE |920 Answer =5
It has many ways, for example: (Assuming all values are in the column "A"): 1) =COUNTIF(A:A;"*") 2) =COUNTA(A:A)-COUNT(A:A)