Can anyone tell me how to....

  • Thread starter Thread starter modicon2
  • Start date Start date
M

modicon2

Does anyone know if there is a function or how I can determine how many
times a specific text is used in a spreadsheet?

Example:
I want to be able to enter a function/equation that will give a value
of the number of times a certain "text" is used.

I've created a large spreadsheet and now I need a count on specific
items used in the spreadsheet.
.........A............ B.............C
1....Valve1.......6"........Manual
2....Valve2.......6"........Auto
3....Valve3.......4"........Manual
4....Valve1.......6"........Manual

In the case above, I'd enter text ref = "Valve1" and would like to see
a result = 2.

Any Help would be greatly appreciated!
Thanks
 
one way:

=COUNTIF(A:C,"Valve1")

which will find cells with only the text "Valve1".

If "Valve1" may be embedded in other text, use

=COUNTIF(A:C,"*Valve1*")
 
modicon2

If you are looking only for whole of cell entries then the countif(
function will do what you require. Online help has a pretty goo
description, post back if you need more.

Please note that if your are looking for a part of a cells contents
this approach will not work. in that case I suggest that you downloa
the flexfind utility at http://www.bmsltd.co.uk/mvp
 
Thanks Everyone!!!
The CountIF function does exactly what I'm looking for.
I can't believe I overlooked it. I thought I looked thru everyone o
those darn functions.

Thanks Again!
Modicon
 
In the following:
=COUNTIF(A:C,"Valve1")

Is there some way to replace "Valve1" with a Cell Ref (exm:A5) that
contains the text that I'm attempting to count?

Thanks a Billion!!!
 
Back
Top