View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline
external usenet poster
 
Posts: 1,071
Default Count Blank Cells & Letter P

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

"Karen" wrote in message
...
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