I'm confused. I'm using Excel 2000 and I cannot get the below formula
to work. I only get #####. The strange thing is that if I change MODE
to AVERAGE or MEDIAN it works fine -- only the MODE function does not
work.

=MODE(Firstsheet:LastSheet!C5:C20)

Thanks if you can help . . . .

AJ