COUNTIF for cells not in sequential order
I am trying to create a countif formula for cells that are not in sequential order. To select the range I am holding down the Ctrl key and the cells appear to be live. When I finish my selection I place a , "criteria") but the formula comes back as incorrect. When I have cells that are sequential I do not experience this problem.
Can someone advise?
Help Article Resources
Check out the Formula Handbook template!