|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
|
|
#1
February 13th 07, 08:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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? > > >
|
|
#4
February 14th 07, 05:28 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? > > > > > >
|
|
#5
February 14th 07, 01:58 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 > 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? >> >> >>
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Hybrid Mode
