Without at least knowing what kinds of dropdowns you're using, or what method you're using to calculate the averages (e.g. VBA, field coding), it's impossible to provide an answer.

Can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]