Countblank formula

[Guest]

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

 

[Rodrigo Ferreira]

Try something like this:

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

 

[Guest]

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?

 

[Guest]

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

 

[Rodrigo Ferreira]

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

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