I was using excel today and I wanted to count all the cells in a range only when there is a value greater than 2. So I started hunting for a funciton in excel and found the countif function.
But when I started using it like this -- Countif(A1:A100,>2) it didn't work. It was coming up with an error.
So I tried Countif(A1:A100,">2"). This worked. So if we include the criteria in quotes then the formula worked.
I also noticed a sumif function that also works in a similar way. It populates the sum of all the cells in the range specified that satisfy the criteria given.