| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate percentage from cells in different worksheets
Hi,
I have data on patients in excel file, with each patient's data placed on a separate sheet. For instance: PatientA has data on worksheet "PatientA" where cell A9 is hemoglobin data .... PatientZ has data on worksheet "PatientZ" where cell A9 is hemoglobin data I have a summary worksheet called "Summary". I need cell A9 in that sheet to give me the percentage of patients whose Hemoglobin value is between 10 and 12. Any help is appreciated. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate percentage from cells in different worksheets
see your other post
-- Biff Microsoft Excel MVP "wissam" wrote in message ... Hi, I have data on patients in excel file, with each patient's data placed on a separate sheet. For instance: PatientA has data on worksheet "PatientA" where cell A9 is hemoglobin data ... PatientZ has data on worksheet "PatientZ" where cell A9 is hemoglobin data I have a summary worksheet called "Summary". I need cell A9 in that sheet to give me the percentage of patients whose Hemoglobin value is between 10 and 12. Any help is appreciated. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate percentage of cells that have any value | Excel Discussion (Misc queries) | |||
| calculate cells over multiple worksheets | Excel Worksheet Functions | |||
| Calculate percentage based on cells with conditional formatting | New Users to Excel | |||
| calculate percentage | Excel Worksheet Functions | |||
| calculate percentage of two cells | Excel Worksheet Functions | |||
Linear Mode
