Help counting multiple Criteria

Giganews Newsgroups
Subject: Help counting multiple Criteria
Posted by:  Penguin817 (u217…@uwe)
Date: Thu, 11 May 2006

Hello - I am trying to count data in EXCEL.  I have a sheet with multiple
columns.  Column F list a name value (IE:  Dr. Smith, Dr. Jones) Column D
list a Delivery Type(IE:  C/S Primary , C/S Repeat or vaginal) and Column G
list the group name (IE: West 6, East 5)

I am trying to count the number of Doctors who delivered babies by C/S.  Then
I want to count the number of Doctors who delivered babies by Vaginal, and
finally the how many babies were delivered by each group.

I was able to total the number of babies delivered vaginally by using:
=SUMPRODUCT(--('Dr McNanley'!F1:F20000="Grunert"),--('Dr McNanley'!D1:
D20000="vaginal"))

I can't get it to count the C/S babies.... Is it because I have a "/"?  I
tried to change it to CSection, and it still did not count it.  I need to to
count whether it says CSection Primary AND CSection Repeat and give me the
total.

Any help would be greatly appreciated!!!!

Replies