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
