Is this possible??

C

coldasice

I have a set of numbers like

90-93
70-86
92-72
91-88
90-89
97-79
76-87

How do I average these numbers without divide by 0 error? please help.
Thank
 
J

Jim

Those are not numbers. In spite of the numerals, they are text because of
the included "-".
 
M

Mark Graesser

What are you trying to average? Is this supposed to be 7 four digit numbers, or 14 two digit numbers. Your division by zero error is because in Excel you don't have any numbers, these are all text. Thus your denominator sums up to zero

Regards
Mark Graesse
(e-mail address removed)

----- coldasice > wrote: ----

I have a set of numbers lik

90-9
70-8
92-7
91-8
90-8
97-7
76-8

How do I average these numbers without divide by 0 error? please help.
Thank
 
R

Ron de Bruin

Use Data>Text to columns in the Menu bar to seperate the numbers from the -

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




Jim said:
Those are not numbers. In spite of the numerals, they are text because of
the included "-".
 
C

coldasice

This is great solution since I can't average the number which include
"-" like Jim memtioned. Thank you very much Ron! Thanks all.
*Use Data>Text to columns in the Menu bar to seperate the number
from the -
 

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

VLOOKUP 2
scatter plot 2
ranking data by a numeric value 2
Nested if using range names 1
Lookup + Max 9
Changing Averages 4
What formulae to derive? 1
Excel 2002 Analysis ToolPak Regression Analysis Help Requested 1

Top