How many males and how many females
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!
|