Follow the instructions on entering the formulas given in my post, Aladin's,
and referenced in Harlan's (look for the *emphasis*).
"Ourania" wrote in message
...
I used the following formulars and for the x value I got a 45 when it
should
be a 55 and for the y value I got a 55 when it should be a 65. What am I
doing wrong?
x values in Rng:
=AVERAGE(--SUBSTITUTE(LEFT(Rng,FIND(",",Rng)-1),"(",""))
y values in Rng:
=AVERAGE(--SUBSTITUTE(MID(Rng,FIND(",",Rng)+1,256),")",""))
" wrote:
Ourania wrote...
I am using an Excel spreadsheet with 2 numbers in every cell separated
my a
comma and a space (45, 55) and want to calculate the average for only
the
left numbers across a variety of cells [(45,55) (55,55) (65,85)].
Here the
averages I am looking for would be 55 for the left set of numbers and
65 for
the right set. I was wondering if there is any way to do this
automatically
in Excel instead of going through and doing them all manually. Any
help you
can provide would be most appreciated.
These are (x, y) pairs? Do they also include the parentheses? Here are
*array* formulas that can deal with parentheses whether they're
included or not.
x values in Rng:
=AVERAGE(--SUBSTITUTE(LEFT(Rng,FIND(",",Rng)-1),"(",""))
y values in Rng:
=AVERAGE(--SUBSTITUTE(MID(Rng,FIND(",",Rng)+1,256),")",""))
|