Help counting multiple Criteria
 

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

Help counting multiple Criteria
 

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

HTH
--
AP

"Penguin817" <u21765@uwe a écrit dans le message de news:
60186300cdcc9@uwe...
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!!!!

Help counting multiple Criteria
 

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

Penguin817 wrote:
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!!!!

Help counting multiple Criteria
 

Works by me!

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

TIA
--
AP

"Penguin817" <u21765@uwe a écrit dans le message de news:
60186300cdcc9@uwe...
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!!!!

Help counting multiple Criteria
 

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" <u21765@uwe wrote in message news:60186300cdcc9@uwe...
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!!!!

Help counting multiple Criteria
 

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


TIA - RN


Ardus Petus wrote:
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!!!!

Help counting multiple Criteria
 

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

HTH
--
AP

"Penguin817" <u21765@uwe a écrit dans le message de news:
6019c923c3e0b@uwe...
I uploaded it: http://cjoint.com/?fltQv0o1Xn


TIA - RN


Ardus Petus wrote:
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!!!!