Filtering A and counting B

S

SAM

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?
 
T

Toppers

No filtering rquired:

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

will count A=blank and B="x"

HTH
 
S

SAM

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Changing language for spell check not working? 1
Filtering within Pivot Table 1
Counting number of days excluding certain values 3
Filtering data 2
Filtering and summing a calculated field on a subform 0
Array counting 3
Advanced Filter not filtering 1

Top