using COUNTIF; but not with a series

[Marilyn]

I need to countif cells contain the letter P. The cells
are not in a series but scattered on the worksheet.
Help! Thank you so much.

 

[drabbacs]

If you mean counting cells that have the letter P and only
the letter P then you can do:

=countif(A1:IV65536,"P") or any range than includes the
area you are interested in.

If you mean the letter p contained in words (peanut,
topheavy, etc) then you need to change the second
argument ("P") to a formula that will look for the letter
P within a string.

 

[Paul Moles]

Answer posted to similar question timed 10:54.

 

[Chris Leonard]

Paul.

What a really useful answer that is!

Marilyn.

Countif works on a RANGE of cells, so, if your cells are scattered about a
worksheet there is nothing you can do.

Well, not quite true.

You could test each cell in turn using the IF statement

or

set yourself a range of cells elsewhere in your worksheet and reference the
cells you want to countif, for example:

Cells F1000 to F1005 might have the following entries in

=A1
=B9
=C88
=E4
=F65

All you need to do then is in your required cell =Countif(F1000:F1005,"P")

Hope this helps you.

Chris