calculate percentage from cells in different worksheets

  • Thread starter Thread starter wissam
  • Start date Start date
W

wissam

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.
 
Back
Top