The IF(COUNT(...)... makes sure there is at least 1 number in the range. If
there were no numbers to average then you'd get a #DIV/0! error.
IF(COUNT(...)... prevents that error. You can remove it if you don't need
it.

--
Biff
Microsoft Excel MVP


"~slacker~" wrote in message
...
thats perfect thanks!

although i don't understand the use of the if. seems it will always
be true and is not needed.