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

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_OUTP UT_TXT_Not_number")

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

You don't need = in the criteria.

--
HTH

Bob Phillips

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

"Paul Lautman" wrote in message
...
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_OUTP UT_TXT_Not_number")

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

Bob Phillips wrote:
You don't need = in the criteria.


"Paul Lautman" wrote in message
...
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_OUTP UT_TXT_Not_number")

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

True

Thanks guys! its just what I needed.


--
Portuga
------------------------------------------------------------------------
Portuga's Profile: http://www.excelforum.com/member.php...fo&userid=6385
View this thread: http://www.excelforum.com/showthread...hreadid=547043