"Peo Sjoblom" <PeoSjoblom@discussions.microsoft.com> wrote...
....
>Otherwise you can use something similar to this link
>
>http://tinyurl.com/7ntmj
>
....

Which uses LARGE((rng),ROW(INDIRECT("1:"&sizeofrng))) to pull all numeric
values from the arbitrary range rng. But it requires less processing time to
use INDEX(FREQUENCY((rng),{5}),2) to count all numbers in rng greater than
5.

For counting, FREQUENCY is usually best. For summing, LARGE or SMALL may
work better.