Evening,
I use this formula to count the number of times the number 2 is in the column:
=COUNTIF('VA Predictions'!AA$2:AA$300,2)
I am now trying to count the times a number:
- higher than 2
- lower than 2
are in the column, I tried this:
=COUNTIF('VA Predictions'!AA$2:AA$300,<2)
but it doesn't like it, any ideas please?
Many thanks
Bookmarks