Count Blank Cells & Letter P

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I have a range of cells from B10:B32 that have a few different values in
them. I want to be able to count the cells that only contain nothing (blanks)
and the letter P. How can this be done?
ANY help would be greatly appreciated, Karen
 
Do you mean to count all the blank cells plus all the cells that have "P"?
Use this: HTH Otto
=COUNTIF(B10:B32,"")+COUNTIF(B10:B32,"P")
 

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

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Counting Results of Formulas 1
Restricting Cell entry to certain letters 7
Simple Count of certain cells 7
COUNTA Function 6
how to count#cells w/= value in other column and not count blank c 4
Excel Countif cell has diagonal border 6
CountIf question 2

Back
Top