How to calculate % in summary sheet from cell A9 in multiple sheet

W

wissam

Dear experts,
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 value.. PatientZ has data on worksheet
"PatientZ" (Sheet50) where cell A9 is hemoglobin value. I have a summary
worksheet called "Summary" (Sheet1). I need cell A9 in the "Summary" (Sheet1)
sheet to give me the percentage of patients whose Hemoglobin value is between
10 and 12 (that is percentage of A9 values in Sheet1 to 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 3
How tcalculate percentage of values in cells in different workshee 0
calculate percent between 10.0 and 12.0 for data in multiple sheet 20
Calculate percent on numbers in different sheets 3
calculate percentage from cells in different worksheets 1
Copying same data range to a summary sheet 8
Copy adjacent Sheet and name from a list 42
do until loop 2

Top