Count Function

P

Portuga

Hi

I have about 60.000 cells of data that are in several rows an
columns.
Ther are several inputs in these cells.

I want to know how many times the input:
-R230_non_conforming_CM_MODEL_OUTPUT_TXT_Not_number- is present in th
sheet.

I could use a pivot but need to do a lot of work before I can have th
data in a good format.

Is there any way I can use the count function to get this total?
Thank
 
S

Sheila D

You can use the COUNTIF function something like

=COUNTIF(1stCell:LastCell,"-R230_non_conforming_CM_MODEL_OUTPUT_TXT_Not_number")
where 1st and last cell are your cell references and your string is enclosed
in ""

HTH - Sheila
 
Top