Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2006

Tip: Looking for answers? Try searching our database.

PivotTable

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Penguin817 - 18 May 2006 14:52 GMT
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!!!!
Penguin817 - 18 May 2006 14:53 GMT
OPPS - It showed the columns nicely when I typed it!!  There are 4 columns

>I am usually really good at figuring things out, but this has me totally
>stumped.  I have a spreadsheet which contains the following headings:
[quoted text clipped - 25 lines]
>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!!!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.