Searching and totalling a keyword

  • Thread starter Thread starter Insomniac
  • Start date Start date
I

Insomniac

Hey guys, I have spreadsheet with several thousand lines which wer
taken from a report I made on the license details from the users
computers here at work.

What I need is a function that will display the number of times
certain serial number shows up in a defined area. E.g. I have rows o
license numbers from Windows XP and I want to know how many version
have license number NMP98-KIND9-SDN96-SKNMD-MDFB8 (that's made up
don't try using it :P). Is there a way to do this?

Cheers for reading
 
Okay, this is all very well if the exact keyword I am searching for i
the only thing in the cell, but if I want to search and count all cell
that have R2MMY-G2M6C-WX9MH-DFBQX-YFT48 in them, but -may- contai
other words, how would I do that?

e.g. I have two cells:

Cell 1» apples, pears
Cell 2» apples

=COUNTIF(A1:A2;"apples")

And I want the result to be 2, not 1. Any ideas? Thanks
 
I have thousands of rows with information that is similar to this:

McAfee (E000-5QJ6-UI66) IE (GKV2D-3TFJ4-3KY4H-M9C2G-8VQFD) Microsof
Windows (GKV2D-3TFJ4-3KY4H-M9C2G-8VQFD) Office 200
(P9X9J-RYRWY-K2JFB-G8F78-78BQY)

Is there no way to just find out how many time
"P9X9J-RYRWY-K2JFB-G8F78-78BQY" appears in all of the selected rows
 
Hi

If you use a wildcard at each end, you'll be there:
=COUNTIF(A1:A2,"*apples*")
will return 2
 
Back
Top