calculate percentage from cells in different worksheets

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.
 

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

Calculate percent on numbers in different sheets 3
calculate percent between 10.0 and 12.0 for data in multiple sheet 20
How tcalculate percentage of values in cells in different workshee 0
How to calculate % in summary sheet from cell A9 in multiple sheet 3
How to calculate % in summary sheet from cell A9 in multiple sheet 0
Dates In Excel 5
Formula: Counting Cells on Different Worksheets 3
Linking to other worksheets 3

Top