Hi,
I am a medical student who's trying to conduct a research project on some medical physiological data that I need to collate. I am pretty new to excel so far as macros and programming so any help would be terrific if you could spare some time.MEWS SHEET 1.xlsx
My problem is that I have used multiple formula to return certain values, once those values have been returned I need to collate the values themselves into a single cell which totals them. Although I realise I can just special paste the combined values into the cell, I also need to maintain the ability to have the formula cells adust any new values that have been entered with subsequent automatic updating of the final cell that totals those values.
I have attached the sheet to this post in the hope sombody may be able to offer a solution. The blue area on the sheet represents the formula cells, the white cells (patient physiological data) represents the variable data input fields and the single orange cell is where I need to enter a formula to tally all the true values obtained from the formula cells.
Hope this makes sense, would really appreciate some guidance
Thank you!
Bookmarks