Thread: Is it possible to ONLY count values that appear within UNHIDDEN ce
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RABrown RABrown is offline
external usenet poster
  
Posts: 3
Default Is it possible to ONLY count values that appear within UNHIDDEN ce
I have several rows of data that are HIDDEN and I don't want to count the
data within them. When I use COUNTIF, it counts the values even in the
hidden rows. Is it possible to restrict the COUNTIF function only to
UNHIDDEN cells?
Reply With QuoteReply With Quote