Hello. Thanks for reading my question. My problem is directly related to
Excel 2003's column limitation of 256. Situation: I have the following array
formula in a cell, which counts the number of numerical entries that occur
three times in the range from A1:IV1 ....
=SUM(IF(COUNTIF($A1:$IV1,$A1:$IV1)=3,1,0))/3. The formula is replicated
downward for 1,000 rows. This works fine. I have several sets of these one
thousand blocks of numbers (separated by blank rows), and therein comes my
pain. The second block of cells begins at A2000. I now need to count two rows
to see how many "three occurrences" there are in ( A1:IV1,
A2000:IV2000........B2:IV2,A2001:IV2001......) . In other words, I want the
formula to 'see' these two ranges as one, if possible. I cannot simply apply
the formula to the second block of cell rows because, as an example, a number
might occur "two times" in A1:IV1 and "one time" in A2000:IV2000 and would
not get counted in the sum. Thank you.