If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Countblank formula
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Countblank formula

#1
February 13th 07, 08:44 PM posted to microsoft.public.excel.worksheet.functions
 EElliott external usenet poster Posts: 2
Countblank formula

How can I count the number of blank cells in one column using the criteria
that cells another column is not blank?
#2
February 13th 07, 10:03 PM posted to microsoft.public.excel.worksheet.functions
 Rodrigo Ferreira external usenet poster Posts: 79
Countblank formula

Try something like this:

SUMPRODUCT(--(A1:A10<>""),--(B1:B10=""))

--

Rodrigo Ferreira

"EElliott" > escreveu na mensagem
...
> How can I count the number of blank cells in one column using the criteria
> that cells another column is not blank?

#3
February 13th 07, 10:19 PM posted to microsoft.public.excel.worksheet.functions
 EElliott external usenet poster Posts: 2
Countblank formula

Thanks Rodrigo. But I'm not sure this formula will work since I don't need
to add values. The data that I need to evaluate is text. I'm trying to use
dates in one column and individuals' names in another column and I want to
count the total number of uncompleted tasks for each individual. Can this be
done?

"Rodrigo Ferreira" wrote:

> Try something like this:
>
> SUMPRODUCT(--(A1:A10<>""),--(B1:B10=""))
>
> --
>
> Rodrigo Ferreira
>
>
> "EElliott" > escreveu na mensagem
> ...
> > How can I count the number of blank cells in one column using the criteria
> > that cells another column is not blank?

>
>
>

#4
February 14th 07, 05:28 AM posted to microsoft.public.excel.worksheet.functions
 JMB external usenet poster Posts: 2,062
Countblank formula

You're not sure makes it sound like you did not try it before replying. Does
it, or does it not work?

"EElliott" wrote:

> Thanks Rodrigo. But I'm not sure this formula will work since I don't need
> to add values. The data that I need to evaluate is text. I'm trying to use
> dates in one column and individuals' names in another column and I want to
> count the total number of uncompleted tasks for each individual. Can this be
> done?
>
> "Rodrigo Ferreira" wrote:
>
> > Try something like this:
> >
> > SUMPRODUCT(--(A1:A10<>""),--(B1:B10=""))
> >
> > --
> >
> > Rodrigo Ferreira
> >
> >
> > "EElliott" > escreveu na mensagem
> > ...
> > > How can I count the number of blank cells in one column using the criteria
> > > that cells another column is not blank?

> >
> >
> >

#5
February 14th 07, 01:58 PM posted to microsoft.public.excel.worksheet.functions
 Rodrigo Ferreira external usenet poster Posts: 79
Countblank formula

If I understood...
Column A = Name
Column B = Date - Begin
Column C = Date - End

D = SUMPRODUCT( --(A1:A10="Rodrigo"), --(B1:B10<>""), --(C1:C10=""))

--

Rodrigo Ferreira

"EElliott" > escreveu na mensagem
news
> Thanks Rodrigo. But I'm not sure this formula will work since I don't
> need
> to add values. The data that I need to evaluate is text. I'm trying to
> use
> dates in one column and individuals' names in another column and I want to
> count the total number of uncompleted tasks for each individual. Can this
> be
> done?
>
> "Rodrigo Ferreira" wrote:
>
>> Try something like this:
>>
>> SUMPRODUCT(--(A1:A10<>""),--(B1:B10=""))
>>
>> --
>>
>> Rodrigo Ferreira
>>
>>
>> "EElliott" > escreveu na mensagem
>> ...
>> > How can I count the number of blank cells in one column using the
>> > criteria
>> > that cells another column is not blank?

>>
>>
>>

 Thread Tools Display Modes Hybrid Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post COUNTBLANK MAX question Vasilis Tergen Excel Discussion (Misc queries) 2 January 4th 07 08:38 AM COUNTBLANK function Latika Excel Worksheet Functions 2 July 10th 06 05:20 PM COUNTBLANK function Ian P Excel Worksheet Functions 4 May 21st 06 06:49 PM COUNTBLANK function Ian P Excel Worksheet Functions 6 May 19th 06 06:52 PM Exceptions to =Countblank function JackBall Excel Worksheet Functions 3 March 24th 06 08:22 PM

All times are GMT +1. The time now is 09:37 AM.