using COUNTIF; but not with a series

D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top