| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate percent between 10.0 and 12.0 for data in multiple sheet
Hi,
I have data of blood test results for patients in an excel file, with each patient's data being placed on one worksheet. For instance: Data for PatientA are in worksheet called "PatientA" where cell A9 is patient's Hemoglobin value Data for PatientB are in worksheet called "PatientB", where cell A9 is patient's Hemoglobin value ...... Data for PatientZ are in worksheet called "PatientZ"; cell A9 is patient's Hemoglobin value I need to create a summary sheet, where A9 in the summary sheet would give me the percentage of among all patients (PatientA to PatientZ) where Hemoglobin level is between 10 and 12 Any help would be appreciated. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate percent | Excel Discussion (Misc queries) | |||
| Calculate Percent in a Column | Excel Discussion (Misc queries) | |||
| How to calculate and then show up as a percent? | Excel Worksheet Functions | |||
| calculate percent increase | Excel Discussion (Misc queries) | |||
| calculate percent from multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
