Prev: Why can't I use the MONTH function within the SUMIFS statement
Next: MSNstockquotes option quotes
From: Steve Stad on 29 Mar 2010 10:59
Can you use the 'or' with a countif to count blanks -- if so can you tell me
how?
For example trying to count blanks in a column of data where the range, eg.,
b1:b100 is blank. ..criteria is something like <A or <1.
From: T. Valko on 29 Mar 2010 11:07
It's not real clear what you want to do.

See if this does what you want.

=COUNTBLANK(B1:B100)

That will count *both* empty cells and cells that contain formula blanks
within the range.

--
Biff
Microsoft Excel MVP


"Steve Stad" <SteveStad(a)discussions.microsoft.com> wrote in message
news:C385250F-AB8E-4771-95BA-75C951E22A14(a)microsoft.com...
> Can you use the 'or' with a countif to count blanks -- if so can you tell
> me
> how?
> For example trying to count blanks in a column of data where the range,
> eg.,
> b1:b100 is blank. ..criteria is something like <A or <1.


From: Steve Stad on 29 Mar 2010 12:36
Thanks T Valko,

Your answer addressed precisely what I was trying to do.
Sorry my question was not as clear. I was not aware of the 'countblank'
function.

Steve

"T. Valko" wrote:

> It's not real clear what you want to do.
>
> See if this does what you want.
>
> =COUNTBLANK(B1:B100)
>
> That will count *both* empty cells and cells that contain formula blanks
> within the range.
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Steve Stad" <SteveStad(a)discussions.microsoft.com> wrote in message
> news:C385250F-AB8E-4771-95BA-75C951E22A14(a)microsoft.com...
> > Can you use the 'or' with a countif to count blanks -- if so can you tell
> > me
> > how?
> > For example trying to count blanks in a column of data where the range,
> > eg.,
> > b1:b100 is blank. ..criteria is something like <A or <1.
>
>
> .
>
From: T. Valko on 29 Mar 2010 14:14
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Steve Stad" <SteveStad(a)discussions.microsoft.com> wrote in message
news:5697D16E-7978-42C9-87CA-00AD5345830D(a)microsoft.com...
> Thanks T Valko,
>
> Your answer addressed precisely what I was trying to do.
> Sorry my question was not as clear. I was not aware of the 'countblank'
> function.
>
> Steve
>
> "T. Valko" wrote:
>
>> It's not real clear what you want to do.
>>
>> See if this does what you want.
>>
>> =COUNTBLANK(B1:B100)
>>
>> That will count *both* empty cells and cells that contain formula blanks
>> within the range.
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Steve Stad" <SteveStad(a)discussions.microsoft.com> wrote in message
>> news:C385250F-AB8E-4771-95BA-75C951E22A14(a)microsoft.com...
>> > Can you use the 'or' with a countif to count blanks -- if so can you
>> > tell
>> > me
>> > how?
>> > For example trying to count blanks in a column of data where the range,
>> > eg.,
>> > b1:b100 is blank. ..criteria is something like <A or <1.
>>
>>
>> .
>>


 | 
Pages: 1
Prev: Why can't I use the MONTH function within the SUMIFS statement
Next: MSNstockquotes option quotes