Is this possible??

[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

 

[Jim]

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

 

[Chip Pearson]

Which numbers do you want to average?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

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

 

[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)

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

 

[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 -