View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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?