counting embedded text

S

Shocked

I have a spreadsheet that I have been tracking complaints on. I
includes the complaint number, company (and location if a distributor),
the date opened, date closed, nature of the complaint, and
valid/not-valid/root cause. There are additional columns that get
filled in with x's for the manufacturing location of the product and
product lines.

I have searched the forum and have been unable to locate how to count
the occurances of "valid" complaints and "not-valid" complaints. I
have used the find function and that works ok but I would rather use
countif if at all possible.

My ultimate goal is to create a Pareto chart on the various companies
and another chart on the root causes. But, before I do that, I want
some simple statistics first.
 
C

Chewy

Try this:
choose a range ... A5:H98 (probably the complaints column with the valid vs.
non valid items)
Choose what word you want to count

=COUNTIF(A5:H98,"Valid")
 
C

CycleZen

It sounds do-able, but how you approach it will depend on how the
information is formatted. Do the words "valid" and "not valid" appear alone
in the Root Cause column? If that is the case then using cell range A1: A10
as the root cause column, you're correct: you can use the formula
=COUNTIF(A1:A10,"valid)

How does your data appear?
 
C

CycleZen

Seems as though it should be do-able: it depends on how your information is
formatted. Do the words "valid" and "invalid" appear as the entries in the
root
cause column? If yes, and assuming the root cause column is A1:A10, the
formula is
=COUNTIF(A1:A10,"valid")

How does your data appear?
 
Top