Problems with basic function average

B

brian.baker13

Hi

I have dumped a load of data from my mrp system into excel for
analysis.

I have a problem that when I go to select data for an average I get a
#div0# error. When I go to do the average by selecting the area above
my bottom task bar the average function is missing and I can only
choose count.

Could you please help.

Thanks

Brian
 
W

Wigi

Hello Brian

You should make sure that the numbers are real numbers, and not some
"textnumbers" (they're text and not numbers)
 
Top