Count Function

[Portuga]

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

[Paul Lautman]

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

Do you mean something like:

=COUNTIF(alls2,"=R230_non_conforming_CM_MODEL_OUTPUT_TXT_Not_number")

where alls2 is a range name referring to all the cells in sheet2 (or
whatever sheet you are using)?

[Bob Phillips]

You don't need = in the criteria.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Paul Lautman" <[email protected]> wrote in message
news:[email protected]...
> 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
>
> Do you mean something like:
>
> =COUNTIF(alls2,"=R230_non_conforming_CM_MODEL_OUTPUT_TXT_Not_number")
>
> where alls2 is a range name referring to all the cells in sheet2 (or
> whatever sheet you are using)?
>
>

[Paul Lautman]

Bob Phillips wrote:
> You don't need = in the criteria.
>
>
> "Paul Lautman" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>> Do you mean something like:
>>
>> =COUNTIF(alls2,"=R230_non_conforming_CM_MODEL_OUTPUT_TXT_Not_number")
>>
>> where alls2 is a range name referring to all the cells in sheet2 (or
>> whatever sheet you are using)?

True

[Portuga]

Thanks guys! its just what I needed.