Count Blank Cells & Letter P
 

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

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

Count Blank Cells & Letter P
 

Hi,

Try this

=sumproduct((B10:B32="")+(B10:B32="p"))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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

Count Blank Cells & Letter P
 

Thank you so much for your help! It worked great!
Karen

"Otto Moehrbach" wrote:

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

.

Count Blank Cells & Letter P
 

Thank you so much for your help! It worked great!
Karen

"Otto Moehrbach" wrote:

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

.

Count Blank Cells & Letter P
 

Thank you so much for your help! It worked great!
Karen

"Ashish Mathur" wrote:

Hi,

Try this

=sumproduct((B10:B32="")+(B10:B32="p"))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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

.

Count Blank Cells & Letter P
 

You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Karen" wrote in message
...
Thank you so much for your help! It worked great!
Karen

"Ashish Mathur" wrote:

Hi,

Try this

=sumproduct((B10:B32="")+(B10:B32="p"))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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

.