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.