Thread: How do I reference an Excel filtered list in a function?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic Domenic is offline
external usenet poster
  
Posts: 256
Default How do I reference an Excel filtered list in a function?
Assuming that you'd like to count the number of cells in Column B that
meet the criteria, in a filtered list, try...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B100,ROW(B2:B100)-ROW(B2),0,1)),--(B2:B1
00="Criteria"))

If the criteria is a numerical value, remove the quotes.

Hope this helps!

In article ,
gordo wrote:

I'd like to use a COUNTIF function with criteria being all visible rows set
in the column filter. Thanks-
Reply With QuoteReply With Quote