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!