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
|