Hi
it would be much easier if you could split it in two separate column (and
then using AVERAGE). But if you have to use it this way try:
Use the following array formula (entered with CTRL+SHIFT+ENTER):
=ROUND(AVERAGE(--LEFT(A1:A3,FIND("/",A1:A3)-1)),0) & "/" &
ROUND(AVERAGE(--MID(A1:A3,FIND("/",A1:A3)+1,10)),0)


"hjvn1302" wrote:

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