View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
falcon491 falcon491 is offline
external usenet poster
 
Posts: 2
Default COUNTIF FUNCTION

What would the sytax be to do a countif() function with a dynamic range? For
instance: =CountIf($H$3:$J$(value of cell A3),"=1")
Thank You very much