Countif on Formula Column

MatR ✭✭
edited 12/09/19 in Formulas and Functions

Can someone tell me what I'm doing wrong?

I want to count all entries in a column that say 'Exceeds'. The formula I have in place is this:

=COUNTIF([Q4 Performance]:[Q4 Performance], "Exceeds")

The answer it is returning is the '#Invalid Operation' error.

The only thing I can think of is that the entries in [Q4 Performance] are formula results, i.e. if a different column is over a certain figure then [Q4 Performance] says Exceeds, if it is under that figure it says Not Achieved. Could this be the problem? If it is, how do I count entries in this column?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!