Try this:
=SUMPRODUCT(--((A1:A10)=AVERAGE(A1:A10)))

Does that help?

***********
Regards,
Ron


"Confuddled User!!!!!!!!!!!!!" wrote:

1. We have a list of numbers.
2. We need to calculate the average of the numbers
3. We need to know how many numbers in the series are equal to, or greater
than the average.

This works well in two stages ie. =Average then =countif......but if these
are nested
as a single function Excel returns a zero value.

Are we completely stupid (sensible answers only), or have we missed the
point of Excel completely.

Also, using the wonderful expression builders, returns the same zero value.

Winner is entitled to a lifetimes supply of Cranberry Juice.