G
Guest
I want to be able to count how many cells hold numbers which are greater than
the average of the cells. I have a cell which shows the average and want to
be able to refer to that cell in the criteria for the COUNTIF function.
For example, if the cells to be counted are in A1:A10 and the average of
those is in A11 I have tried COUNTIF(A1:A10,â€>A11†but it doesn’t work!
I am using 2003
the average of the cells. I have a cell which shows the average and want to
be able to refer to that cell in the criteria for the COUNTIF function.
For example, if the cells to be counted are in A1:A10 and the average of
those is in A11 I have tried COUNTIF(A1:A10,â€>A11†but it doesn’t work!
I am using 2003