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.

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.