|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:
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
Any help would be greatly appreciated!!!!