Excel 2007 : multiple formulas into one cell with autoupdate of subsequent values entered

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!

Your attachment produces an error upon opening that says data is unreadable... please retry attachment.

Thanks, just reloaded, hope this one works: removed macro

Still same issue... be sure to remove unnecessary stuff... links, pictures, macros...

Try:

=SUM(IF(ISNUMBER(D4:K11+0),D4:K11+0))

confirmed with CTRL+SHIFT+ENTER not just ENTER

Note: In all your "blue zone" formulas, the numbers should not be in quotes.. as they are text strings when in quotes.. this makes it necessary to add the +0 in the formula above to convert...

After you entered the formula did you hold the CTRL and SHIFT keys down and press ENTER?

Go to the cell and hit F2 to re-activate the formula and then do the above.

That is weird, when I re-opened your file it (which still gives error, but allows repair), your sheet is formatted in R1C1 style.. so the formula didn't work again

Not sure what your original is like, but if your column headers are numbers rather than letters, you need to change to normal format... go to the Office Button and click Excel Options.. select Formulas and uncheck R1C1 reference style.. then try the formula again...

Yeah, there was something definitely corrupt about your original file. That's why it could not be opened so easily....

Please mark the thread as [Solved]

No Problem. You are very welcome