Count function seeing formulas as data
On Sun, 6 Jun 2010 05:52:02 -0700, robinessex
wrote:
Can you change the count function seeing formulas in cells as data. This
makes the function completely useless. I have an array 1000 cells X 500
cells. I need the count function to check on the number of occurances a
particular value is exceeded. The data is read into each of these cells by a
formula.
Don't use the COUNT function.
=COUNTIF(your_array,"particular_value")
will probably do what you want.
or
=COUNTIF(your_array,""&cell_ref)
where cell_ref is the address of a cell that contains the value you
wish to see exceeded.
|