EXCEL table the number of statistical problems BOC

Users questions: EXCEL table in a large number of data screening based on a condition number of rows in the table how fast statistics?
Experts answer: insert a classified as "counting out", one per line 1, after screening out the bottom of the input in technology SUBTOTAL (9 ,**), screening for other conditions can be Travel a few statistics. Otherwise set to be more complicated. Attachment: the number of lines screened seeking. Xls
  • This information provided by the users.Thanks!