Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count how many rows contain nonblank in column A and blank in colu
How do I count how many rows contain nonblank in col A and blank in col B? It
has to be a combination of both. If you find a nonblank in col A then check col B in this row, if it is blank then count this row in. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
count how many rows contain nonblank in column A and blank in colu
I wanted to clarify... Column A has a decision date and column B should have
that decision. If I have a date without a decision then I want to contact this person to get his/her decision. Thank you. "Vic" wrote: How do I count how many rows contain nonblank in col A and blank in col B? It has to be a combination of both. If you find a nonblank in col A then check col B in this row, if it is blank then count this row in. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
count how many rows contain nonblank in column A and blank in colu
=SUMPRODUCT((ISBLANK(A2:A100))*(ISBLANK(B2:B100)))
Adjust range sizes as desired. Note that with SUMPRODUCT, range sizes must be equal. You can not callout the entire column (i.e., A:A) unless you're using XL 2007. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Vic" wrote: How do I count how many rows contain nonblank in col A and blank in col B? It has to be a combination of both. If you find a nonblank in col A then check col B in this row, if it is blank then count this row in. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
count how many rows contain nonblank in column A and blank in
This formula counts combination of blanks in both columns. My task is to
locate NON-BLANK in A and then check B. If B is blank then I want to count this row in. "Luke M" wrote: =SUMPRODUCT((ISBLANK(A2:A100))*(ISBLANK(B2:B100))) Adjust range sizes as desired. Note that with SUMPRODUCT, range sizes must be equal. You can not callout the entire column (i.e., A:A) unless you're using XL 2007. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Vic" wrote: How do I count how many rows contain nonblank in col A and blank in col B? It has to be a combination of both. If you find a nonblank in col A then check col B in this row, if it is blank then count this row in. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
count how many rows contain nonblank in column A and blank in
Oops! Tweaked formula:
=SUMPRODUCT((NOT(ISBLANK(A2:A100)))*(ISBLANK(B2:B1 00))) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Vic" wrote: This formula counts combination of blanks in both columns. My task is to locate NON-BLANK in A and then check B. If B is blank then I want to count this row in. "Luke M" wrote: =SUMPRODUCT((ISBLANK(A2:A100))*(ISBLANK(B2:B100))) Adjust range sizes as desired. Note that with SUMPRODUCT, range sizes must be equal. You can not callout the entire column (i.e., A:A) unless you're using XL 2007. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Vic" wrote: How do I count how many rows contain nonblank in col A and blank in col B? It has to be a combination of both. If you find a nonblank in col A then check col B in this row, if it is blank then count this row in. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
count how many rows contain nonblank in column A and blank in
Thank you.
"Luke M" wrote: Oops! Tweaked formula: =SUMPRODUCT((NOT(ISBLANK(A2:A100)))*(ISBLANK(B2:B1 00))) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Vic" wrote: This formula counts combination of blanks in both columns. My task is to locate NON-BLANK in A and then check B. If B is blank then I want to count this row in. "Luke M" wrote: =SUMPRODUCT((ISBLANK(A2:A100))*(ISBLANK(B2:B100))) Adjust range sizes as desired. Note that with SUMPRODUCT, range sizes must be equal. You can not callout the entire column (i.e., A:A) unless you're using XL 2007. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Vic" wrote: How do I count how many rows contain nonblank in col A and blank in col B? It has to be a combination of both. If you find a nonblank in col A then check col B in this row, if it is blank then count this row in. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
Count nonblank cells based on another column | Excel Worksheet Functions | |||
How do I count non blank rows only? | New Users to Excel | |||
Count no. of nonblank cells in one column based on criteria of ano | Excel Discussion (Misc queries) | |||
How do I count nonblank cells in rows within Excel? | New Users to Excel |