Count function seeing formulas as data
Think COUNTIF is what you're after, not COUNT
Try something like this:
=COUNTIF(D2:F4,"=2")
which returns the number of cells within D2:F4 containing numbers greater
than or equal to 2. Adapt the range and condition to suit your actuals.
--
Max
Singapore
---
"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
|