How tcalculate percentage of values in cells in different workshee

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"
(Sheet2) where cell A9 is hemoglobin data ... PatientZ has data on worksheet
"PatientZ" (Sheet50) where cell A9 is hemoglobin data I have a summary
worksheet called "Summary" (Sheet1). I need cell A9 in sheet1 to give me the
percentage of patients whose Hemoglobin value is between 10 and 12 (that is %
of A9 in Sheet1 till Sheet50 with value between 10 and 12).
Any help is appreciated. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to calculate % in summary sheet from cell A9 in multiple sheet 0
How to calculate % in summary sheet from cell A9 in multiple sheet 3
calculate percentage from cells in different worksheets 1
Calculate percent on numbers in different sheets 3
calculate percent between 10.0 and 12.0 for data in multiple sheet 20
Remove specific cells in a column. 2
fill in data that is not empty 1
Using =Offset in Charts 1

Top