iWork'08 sumifs equivalent in Numbers
Numbers 09 has the SUMIFS function, which operates the same as in Excel. Numbers 08 does not appear to have it, but it has SUMIF.

You should still be able to do what you are trying by combining two logical statements.

Without using the function, you could also build a new column by multiplying values by a logical statement. For example:

=A3 + A4 × (B4&gt;2) 


This will only add A4 if B4 is greater than 2...

Or in your example, make a column using AND:

=A2 x AND(B2&lt;10,exact(C2,"female))


Then sum that column. Values that don't meet both criteria will be zero.