PivotTable

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

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

[Penguin817 via OfficeKB.com]

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