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