You could try this to cater for that

=ROUND(AVERAGE(IF((B1:B100<"")*(ISNUMBER(--LEFT(B1:B100,3))),--LEFT(B1:B100
,3))),0)&"/"&
ROUND(AVERAGE(IF((B1:B100<"")*(ISNUMBER(--LEFT(B1:B100,2))),--RIGHT(B1:B100
,2))),0)

still as an array

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"gadmire" wrote in message
...
Bob:

Thanks for the recommendation.

It worked perfectly after I started the formula at B3 ( B1 and B2
contained
text which prevented correct operation of the formula).

Bob


"Bob Phillips" wrote:

Reading between the lines


=ROUND(AVERAGE(IF(A1:A100<"",--LEFT(A1:A100,3))),0)&"/"&ROUND(AVERAGE(IF(A1
:A100<"",--RIGHT(A1:A100,2))),0)

which is an array formula, it should be committed with Ctrl-Shift-Enter,
not
just Enter.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"gadmire" wrote in message
...
I am trying to obtain an average of blood pressure over a period of
time.
The individual entries are in a single column but are in a combined
format
(e.g. 130/82). I need to parse each of the two numbers and arrive at
an
average of all entries in the column. I have searched help because I
thought
I had seen some reference to the selecting only a portion of a number
on a
prior search. Unfortunately, I could not come across it again.
Thanks
for
any help