How many males and how many females

[Guest]

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!

 

[Ron Coderre]

Try something like this:

=SUMPRODUCT((C2:C100="MALE")*(L2:L1000>0))

Change range references to suit your situation.

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

Regards,

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

 

[Guest]

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

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

 

[Guest]

Great thanks!

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

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

 

[Guest]

Great thanks!

Try something like this:

=SUMPRODUCT((C2:C100="MALE")*(L2:L1000>0))

Change range references to suit your situation.

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

Regards,

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