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

"Portuga" wrote:

>
> Hi
>
> I have about 60.000 cells of data that are in several rows and
> 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 the
> sheet.
>
> I could use a pivot but need to do a lot of work before I can have the
> data in a good format.
>
> Is there any way I can use the count function to get this total?
> Thanks
>
>
> --
> Portuga
> ------------------------------------------------------------------------
> Portuga's Profile: http://www.excelforum.com/member.php...fo&userid=6385
> View this thread: http://www.excelforum.com/showthread...hreadid=547043
>
>