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?