Thread: How do I count cells that contain one of several specific numbers?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lewis0205NC
 
Posts: n/a
Default How do I count cells that contain one of several specific numbers?
I am trying to count the number of cells in a row that contain 1 to 5 but I
cells are not adjacent. I am counting from every 3rd column cells which
contain 1, 2, 3, 4, or 5. I tried using the
=COUNTIF(A1,A4,A7,A10,A13,A16,"1:5") but that obviously didn't work. Any
advise?
Reply With QuoteReply With Quote