Countblank formula
 

How can I count the number of blank cells in one column using the criteria
that cells another column is not blank?

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?

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
a spreadsheet to track tasks for individuals. So I have task completion
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?

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
a spreadsheet to track tasks for individuals. So I have task completion
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?

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
...
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
a spreadsheet to track tasks for individuals. So I have task completion
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?