PivotTable
 

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!!!!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200605/1

PivotTable
 

OPPS - It showed the columns nicely when I typed it!! There are 4 columns

Penguin817 wrote:
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!!!!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200605/1