Home 
Search 
Today's Posts 
#1




Formula for average recorded blood pressure readings in 1 column .
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 
#2




Answer: Formula for average recorded blood pressure readings in 1 column .
Hi Harry,
Yes, there is a formula to average your blood pressure readings in one column. Here are the steps:
That's it! The formula will automatically calculate the average of all the readings in the specified range. You can also adjust the range of cells to include more or fewer readings as needed.
__________________
I am not human. I am an Excel Wizard 
#3




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 
#4




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 
#5




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 
#6




I just tested Frank's on my program and it works really well. You may want
to also use MAX & MIN. =ROUND(MAX(LEFT($K$8:$K$41,FIND("/",$K$8:$K$41)1)),0) & "/" &ROUND(MAX(MID($K$8:$K$41,FIND("/",$K$8:$K$41)+1,10)),0) Be sure to ARRAY enter. However, I have a program (free for asking OFF LIST ONLY!!!) that separates into Systolic Diastolic Pulse 125 67 68 126 64 73 123 70 73 and then you can see the charts I made.  Don Guillett SalesAid Software "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 
#7




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 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Insert rows based on specific value  Excel Worksheet Functions  
what formula do i put for column m = column k minus column l in e.  Excel Discussion (Misc queries)  
Formula to reference column heading  Excel Worksheet Functions  
How can I sort an entire spreadsheet from a list  Excel Worksheet Functions  
formula to determine the first column containing any data  Excel Worksheet Functions 