View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gordo gordo is offline
external usenet poster
 
Posts: 10
Default COUNTIF on an autofilter?

I'd like to base a COUNTIF calculation on the rows displayed after an
autofilter. I've been trying combinations of COUNTIF and SUBTOTAL without
success.

Basically, I set an autofilter on column-A then perform a COUNTIF on
column-B to calculate occurrences of text values.

Thanks for any suggestions!