Thread: using countif in a filtered range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mr E Mr E is offline
external usenet poster
  
Posts: 1
Default using countif in a filtered range
is it possible to use countif in a range that has been filtered?
my formula seems to be counting all data in the range.
=COUNTIF(Q11:Q301,"249")

your help would be greatly appreciated
Reply With QuoteReply With Quote