Filtering A and counting B
 

Hi!

This is my problem:
I have a worksheet with only "x" (as a check mark) in cells. I have filtered
column A in order to see only the blank cells of A. Now I need to count the
check marks that still are visible in col B after the filtering of A.

I've been checking previous questions here and trying its answers but I dont
succeed. I've even tried SUBTOTAL function, so if still that is the answer,
could anybody explain it to me in an easier language than in Excel's Help?

Filtering A and counting B
 

No filtering rquired:

=SUMPRODUCT(--(A1:A100=""),--(B1:B100="x"))

will count A=blank and B="x"

HTH

"SAM" wrote:

Hi!

This is my problem:
I have a worksheet with only "x" (as a check mark) in cells. I have filtered
column A in order to see only the blank cells of A. Now I need to count the
check marks that still are visible in col B after the filtering of A.

I've been checking previous questions here and trying its answers but I dont
succeed. I've even tried SUBTOTAL function, so if still that is the answer,
could anybody explain it to me in an easier language than in Excel's Help?

Filtering A and counting B
 

It didn't work at the biginning, but the program itself said what it had to
be changed: the (,) for a (;).

Thank you VERY MUCH for your help, Toppers!

Sam

"Toppers" wrote:

No filtering rquired:

=SUMPRODUCT(--(A1:A100=""),--(B1:B100="x"))

will count A=blank and B="x"

HTH

"SAM" wrote:

Hi!

This is my problem:
I have a worksheet with only "x" (as a check mark) in cells. I have filtered
column A in order to see only the blank cells of A. Now I need to count the
check marks that still are visible in col B after the filtering of A.

I've been checking previous questions here and trying its answers but I dont
succeed. I've even tried SUBTOTAL function, so if still that is the answer,
could anybody explain it to me in an easier language than in Excel's Help?