using COUNTIF; but not with a series

  • Thread starter Thread starter Marilyn
  • Start date Start date
M

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.
 
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.

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
 
Back
Top