Hi,

You may use pivot tables.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Tia" wrote in message
...
Hello,

I have this work book with job titles, names and genders
C10=Name
D10=Job Title
E=Gender (female or male)
F10=Basic Salary
G10=Transportation.........
what i need is to find the total of females only in each job title


Best Regards