View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
shakey1181 shakey1181 is offline
external usenet poster
 
Posts: 27
Default countif from specific range

I am trying to count data which falls within a specific non-sequential range.
So i basically only want to count if the a1:a100 is equal to:
11,12,13,15,18,89,88,69,56, but i can't seem to find a way around it that
doesn't error

Would it help if i used a named range?

Thanks in advance.