Hello, I have a number of COUNTIF functions that I need to work with different ranges that will be changed by a particular variable. In other words I am trying to write COUNTIF(C1:Cx,1) where x is the output of a specific cell. I am totally stumped on this. Thanks in advance for any help.