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