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.
|