PivotTable

  • Thread starter Penguin817 via OfficeKB.com
  • Start date
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!!!!
 
P

Penguin817 via OfficeKB.com

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

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

Top