Why the #DIV/0 error???

B

Brandy

Good Afternoon All (depending on where you are in the world)!

So I am trying to sort some data using drop down lists and I am averaging
scores that have already been averaged.

I averaged five numbers horizontally and then copied over the formulas with
values. Then I selected only one item from the drop-down menu and tried to
average those values vertically but I get the #DIV/0 error. There are no
zeros anywhere in the values.

Any help would be greatly appreciated!

Brandy
 
A

Alan

Can you post back the formulas, the values and how you constructed the drop
down menu? It's hard to visualise what you mean.

By the way,

'I am averaging scores that have already been averaged'

Averaging averages is fraught with danger, you can get false results very
easily, in fact nearly always.

Regards,
Alan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#div/0 error 2
How do I make #DIV/0! error message go away? 2
#DIV/0! error 1
#Div/0 and Function OR 3
#DIV/0! ERROR 2
Conditional formula yeilds non-number result 6
#DIV/0! 5
if cell in other worksheet meets criteria, then leave blank. 1

Top