easy "countif" formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Cells B1:B50 have the letter p in the cell or the cell is blank. I would like
cell B51 to count the number of P's in cells B1:B50. I appreciate help with
this simple formula.
 
=countif(b1:b50,"p")

may work for you.
Cells B1:B50 have the letter p in the cell or the cell is blank. I would like
cell B51 to count the number of P's in cells B1:B50. I appreciate help with
this simple formula.
Click to expand...
 

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

Similar Threads

easy countif formula again 6
Counting non blanks different from "" 4
Counting with a condition disregarding errors 7
Question on looking up data 2
SUMIF with criteria "<>" & "=" 4
Using two formulae 3
How to marry two working countif formulas? 9
simple countif formula 2

Back
Top