Hi JulieD,

Your formula worked out great, however, my average goes out to 10 decimal
places on the upper number. How can I correct?

Thanks JimT

"JulieD" wrote:

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