One way:
http://img245.imageshack.us/img245/5199/nonamew.png
Note:
An Array formula needs to be entered by using the combination of
CTRL+SHIFT+ENTER (instead of ENTER).
DO NOT type the curly braces { }. Excel will display them automatically !
Micky


"CGI" wrote:

I would like to count a range if all the numbers in that range meet a stated
criteria. For example I have 50 columns (so 50 ranges) and I want to see how
many of these cloumns contain numbers that are all above 75.

e.g. Column 1 has 76, 76, 78, 90 so that would be counted, Column 2 has 77,
76, 94, 83 so that would be counted also, Column 3 has 72, 76, 77, 79 so that
would not be counted and the total would be 2.

Hope that is somehow understandable - I am a bit of a beginner!