colerainescotty
New Member
- Joined
- Feb 25, 2009
- Messages
- 10
Hi folks, I have a simple excel spreadsheet that I am creating to get better at Excel and formulas for my IT course. I have a spreadsheet with some dummy data related to hospital procedures.
At the moment there are 6 doctors who carry out a procedure. The doctors in theory have to be audited and a report sheet produced. At the moment all of the data in a row relates to a particular doctor. There are various pieces of data I wish to collate for a particular doctor.
Firstly if possible I would like to be able to (for the report) say "Find all rows with Dr. A and calculate total dose of Drug A given to patients"
Here is an example of what I am trying to achieve
Excel Sheet
A B C D
1 Doctor Drug Dose
2 Dr. A 1mg
3 Dr. B 2mg
4 Dr. A 4mg
Is there a formula for me to be able to say in another "reporting" sheet (if row contains "Dr A" then total "drug dose")
If you need anymore information please do not hesitate to reply and I will be happy to answer.
Thanks so much in advance and I may have more questions soon
At the moment there are 6 doctors who carry out a procedure. The doctors in theory have to be audited and a report sheet produced. At the moment all of the data in a row relates to a particular doctor. There are various pieces of data I wish to collate for a particular doctor.
Firstly if possible I would like to be able to (for the report) say "Find all rows with Dr. A and calculate total dose of Drug A given to patients"
Here is an example of what I am trying to achieve
Excel Sheet
A B C D
1 Doctor Drug Dose
2 Dr. A 1mg
3 Dr. B 2mg
4 Dr. A 4mg
Is there a formula for me to be able to say in another "reporting" sheet (if row contains "Dr A" then total "drug dose")
If you need anymore information please do not hesitate to reply and I will be happy to answer.
Thanks so much in advance and I may have more questions soon
