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

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

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

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

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

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

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