Difficult to say without your formula!

--
Kind regards,

Niek Otten

"Confuddled User!!!!!!!!!!!!!" <Confuddled
wrote in message
...
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.