I copied your example in the range A1:B6. Now to get the age of all
females, use the following formula:
=SUMPRODUCT(B1:B6,--(OFFSET(A1:A6,1,0)="f"))
and for males, use:
=SUMPRODUCT(B1:B6,--(OFFSET(A1:A6,1,0)="m"))
Mangesh
--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread:
http://www.excelforum.com/showthread...hreadid=374137