How many males and how many females

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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)
 
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))
 
Great thanks!

claude jerry said:
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))
Click to expand...
 
Great thanks!

Ron Coderre said:
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)
Click to expand...
 
Back
Top