This question was asked in Count by Using Filters
how to count in excel

ankitha .'s image