What are some typical hemoglobin values? Are they intergers (whole numbers)?
Are they decimal numbers to 1 decimal place? Are they decimal numbers to 2
decimal places?

--
Biff
Microsoft Excel MVP


"wissam" wrote in message
...
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.