View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marty Marty is offline
external usenet poster
 
Posts: 116
Default Using countif on non-consecutive cells

How do I use the countif on non-concecutive cells, i.e. I want to know the
number of certain cells in worksheet that contain a specific value. For
instance, how many cells in a1:a5, a7, a15:a18 contain the value of 1.
--
Marty