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?