We help IT Professionals succeed at work.

return the number of cells containing a specific text

wkraft
wkraft used Ask the Experts™
on
I have a column in which cells contain either the words, "CA is required" or "CA is not required."  I need to return the number of cells that contain specifically "CA is required"

Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
If your data is on column A, just use this:

=COUNTIF(A:A,"CA is required")

jppinto
AnilData Manager
Commented:
=COUNTIF(A1:A10000,"CA is required")

repalce range with yours.

A>