P
Penguin817 via OfficeKB.com
I am usually really good at figuring things out, but this has me totally
stumped. I have a spreadsheet which contains the following headings:
C-section Indication Main Method of Delivery Aux Method of Delivery
Physician 1
Vaginal None
Auty
Elective C/S Primary None
Barnett
Vaginal Forceps
Barnett
Elective C/S Repeat None
Bonham
VBAC
None Bostock
I am trying to find out:
the # of C/S by each doctor
the # of Vaginal by each doctor
The % of total births by each doctor
Then they want to know the # of vaginal births after Primary C/S (VBAC)
I have tried a PivotTable (which I have never done before) because everyone
was telling me to use that. I was not able to pull out the info within the
column like I needed. I have tried using the following formula, which
someone was so kind to help me come up with, but it just does not work for me:
=SUMPRODUCT(--('Dr McNanley'!#REF!="Grunert"),--('Dr McNanley'!#REF!="c/s")).
I am at my whits end with this, and no one around me has the knowledge to
assist me. Please some Excel guru help me!!!!! Thank you in advance!!!!
stumped. I have a spreadsheet which contains the following headings:
C-section Indication Main Method of Delivery Aux Method of Delivery
Physician 1
Vaginal None
Auty
Elective C/S Primary None
Barnett
Vaginal Forceps
Barnett
Elective C/S Repeat None
Bonham
VBAC
None Bostock
I am trying to find out:
the # of C/S by each doctor
the # of Vaginal by each doctor
The % of total births by each doctor
Then they want to know the # of vaginal births after Primary C/S (VBAC)
I have tried a PivotTable (which I have never done before) because everyone
was telling me to use that. I was not able to pull out the info within the
column like I needed. I have tried using the following formula, which
someone was so kind to help me come up with, but it just does not work for me:
=SUMPRODUCT(--('Dr McNanley'!#REF!="Grunert"),--('Dr McNanley'!#REF!="c/s")).
I am at my whits end with this, and no one around me has the knowledge to
assist me. Please some Excel guru help me!!!!! Thank you in advance!!!!