Prev: Auto Sum range with multiple columns.
Next: Formula displaying don't know why
From: Karen on 11 Jan 2010 17:07
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

From: Otto Moehrbach on 11 Jan 2010 17:40
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" <Karen(a)discussions.microsoft.com> wrote in message
news:2A361311-80FE-4CE5-9919-FD7FA86E5A09(a)microsoft.com...
> 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
>
From: Ashish Mathur on 11 Jan 2010 20:51
Hi,

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Karen" <Karen(a)discussions.microsoft.com> wrote in message
news:2A361311-80FE-4CE5-9919-FD7FA86E5A09(a)microsoft.com...
> 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
>
From: Karen on 12 Jan 2010 11:42
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" <Karen(a)discussions.microsoft.com> wrote in message
> news:2A361311-80FE-4CE5-9919-FD7FA86E5A09(a)microsoft.com...
> > 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
> >
> .
>
From: Ashish Mathur on 12 Jan 2010 18:44
You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Karen" <Karen(a)discussions.microsoft.com> wrote in message
news:F6472235-38A2-45D1-9A48-EC35DD41325E(a)microsoft.com...
> 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" <Karen(a)discussions.microsoft.com> wrote in message
>> news:2A361311-80FE-4CE5-9919-FD7FA86E5A09(a)microsoft.com...
>> > 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
>> >
>> .
>>
 | 
Pages: 1
Prev: Auto Sum range with multiple columns.
Next: Formula displaying don't know why