Help counting multiple Criteria

[Penguin817]

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

 

[Ardus Petus]

=SUMPRODUCT(--('Dr McNanley'!F1:F20000="Grunert"),('Dr
McNanley'!D120000="C/S Primary")+('Dr McNanley'!D120000="C/S Repeat"))

HTH

 

[Penguin817]

Thanks - but that gave me an error: #REF!

 

[Ardus Petus]

Works by me!

Could you upload your workbook on http://cjoint.com and post the link?

TIA

 

[Liz]

Sounds like a PivotTable would work - you could run the group names down the
left, the Delivery type across the top, and your data section could count
doctors

 

[Penguin817]

I uploaded it: http://cjoint.com/?fltQv0o1Xn


TIA - RN

Works by me!

Could you upload your workbook on http://cjoint.com and post the link?

TIA
--
AP

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

[quoted text clipped - 18 lines]

Any help would be greatly appreciated!!!!

 

[Ardus Petus]

Here is the corrected version : http://cjoint.com/?flusz1KkEu

HTH
--
AP

I uploaded it: http://cjoint.com/?fltQv0o1Xn


TIA - RN

Works by me!

Could you upload your workbook on http://cjoint.com and post the link?

TIA
--
AP

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

[quoted text clipped - 18 lines]

Any help would be greatly appreciated!!!!