Excel spreadsheet average of cells containing multiple variables

[KennethStarick]

I keep a spreadsheet of blood pressure readings which I give to my GP to enable him to see a better picture of my condition.The format is 119/79/75 125/84/69 107/69/73 114/74/75 135/91/73 126/81/85 128/76/78 137/82/63 124/79/69etc on a daily basis..My GP asked if it would be possible to obtain an average at the bottom of each column, but I thought no, as each cell contains 3 variables.Am I wrong, or is there a formula to do this?

Continue reading...