Ok I have the following formula: =COUNTIF(Data!B$1:F$30,[@Ball])
I want to from a drop down menu change the range of the F cell to 40, 60 or any range
=COUNTIF(Data!B$1:F$& C2 ,[@Ball])
=COUNTIF(Data!B$1:F$&"C2",[@Ball])
I tried but I keep getting errors
Thanks in advance
I want to from a drop down menu change the range of the F cell to 40, 60 or any range
=COUNTIF(Data!B$1:F$& C2 ,[@Ball])
=COUNTIF(Data!B$1:F$&"C2",[@Ball])
I tried but I keep getting errors
Thanks in advance