For some reason I can't get the function COUNTIF to work in Excel. When I try to activate it, the second part of the range trows up an error message.
As in =COUNTIF(A1:A20,C1) excel won't run it, and highlights A20 as the part that is the problem.
I'm on a mac computer for the first time in my life, and it's unsettling me, so my normal problem solving skills seem to be failing me. Do I need to run the developer panel in Excel to use that function, or is there something obvious that I'm not doing?
Any help welcomed