Hi

just a note, Frank's formula is more flexible than mine (i've assumed that
the top value is always 3 digits and the bottom always 2) .. so you're
better off going with his formula.

Cheers
JulieD

"JulieD" wrote in message
...
Hi Harry

with you blood pressure readings in A2:A4 the following array formula will
give it to you (needs to be entered with control & shift & enter, not just
enter)

=AVERAGE(VALUE(LEFT(A2:A4,3)))&"/"&ROUND(AVERAGE(VALUE(RIGHT(A2:A4,2))),0)

Cheers
JulieD

"hjvn1302" wrote in message
...
I enter my blood pressure readings for the month in one column. Is there
a
formula to average them? i.e.
120/80
130/76
128/77
______
126/78 is avg
Thanks, Harry