Filtering A and counting B

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
No filtering rquired:

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

will count A=blank and B="x"

HTH
 
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
 
You must log in or register to reply here.

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

COUNTIF Function on filtered data 2
Count if ? formula needed! 3
REPOST: Count certain records in filtered data 5
Filtered Counting 5
Filtering within Pivot Table 1
Auto filter count 3
Count certain records in filtered data 4
Count only visible cells 4

Back
Top