E
EElliott
How can I count the number of blank cells in one column using the criteria
that cells another column is not blank?
that cells another column is not blank?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rodrigo Ferreira
Try something like this:
SUMPRODUCT(--(A1:A10<>""),--(B1:B10=""))
SUMPRODUCT(--(A1:A10<>""),--(B1:B10=""))
E
EElliott
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?
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?
J
JMB
You're not sure makes it sound like you did not try it before replying. Does
it, or does it not work?
it, or does it not work?
R
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=""))
Column A = Name
Column B = Date - Begin
Column C = Date - End
D = SUMPRODUCT( --(A1:A10="Rodrigo"), --(B1:B10<>""), --(C1:C10=""))