Hi

I'm working on attendance record and I'm having a problem with a formula.
I'll try to explain this clearly.

Column C is the gender column. Each cell in this column either says "male"
of "female." Column L is the attendance record column. Each cell in this
column has a numeric value.

I would like to create a formula that tells me how many males have attended
the event. I don't want the formula to include males who have "0" in their
attendance record cell.

I hope this makes sense!

Try something like this:

=SUMPRODUCT((C2:C100="MALE")*(L2:L10000))

Change range references to suit your situation.

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Adam" wrote in message
...
Hi

I'm working on attendance record and I'm having a problem with a formula.
I'll try to explain this clearly.

Column C is the gender column. Each cell in this column either says "male"
of "female." Column L is the attendance record column. Each cell in this
column has a numeric value.

I would like to create a formula that tells me how many males have
attended
the event. I don't want the formula to include males who have "0" in their
attendance record cell.

I hope this makes sense!

To Get males total
=SUMPRODUCT(--(C1:C20="Male"),--(L1:L200))
Assuming Gender are in Range C1:C20 and Attendence is in L1:L20

To Get Females total
=SUMPRODUCT(--(C1:C20="Female"),--(L1:L200))



"Adam" wrote:

Hi

I'm working on attendance record and I'm having a problem with a formula.
I'll try to explain this clearly.

Column C is the gender column. Each cell in this column either says "male"
of "female." Column L is the attendance record column. Each cell in this
column has a numeric value.

I would like to create a formula that tells me how many males have attended
the event. I don't want the formula to include males who have "0" in their
attendance record cell.

I hope this makes sense!

Great thanks!

"claude jerry" wrote:

To Get males total
=SUMPRODUCT(--(C1:C20="Male"),--(L1:L200))
Assuming Gender are in Range C1:C20 and Attendence is in L1:L20

To Get Females total
=SUMPRODUCT(--(C1:C20="Female"),--(L1:L200))



"Adam" wrote:

Hi

I'm working on attendance record and I'm having a problem with a formula.
I'll try to explain this clearly.

Column C is the gender column. Each cell in this column either says "male"
of "female." Column L is the attendance record column. Each cell in this
column has a numeric value.

I would like to create a formula that tells me how many males have attended
the event. I don't want the formula to include males who have "0" in their
attendance record cell.

I hope this makes sense!

Great thanks!

"Ron Coderre" wrote:

Try something like this:

=SUMPRODUCT((C2:C100="MALE")*(L2:L10000))

Change range references to suit your situation.

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Adam" wrote in message
...
Hi

I'm working on attendance record and I'm having a problem with a formula.
I'll try to explain this clearly.

Column C is the gender column. Each cell in this column either says "male"
of "female." Column L is the attendance record column. Each cell in this
column has a numeric value.

I would like to create a formula that tells me how many males have
attended
the event. I don't want the formula to include males who have "0" in their
attendance record cell.

I hope this makes sense!