Total of Females in a worksheet

  • Thread starter Thread starter Tia
  • Start date Start date
T

Tia

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
 
Hi,

You may use pivot tables.

--
Regards,

Ashish Mathur
Microsoft Excel MVPwww.ashishmathur.com








- Show quoted text -
Click to expand...

:( i dont know how i wana have it as a general at the end of the sheet
total of female of each job title

Example :
Jack De Tores : Supervior: Female
John: Waiter: Male
Ruby: Supervisor: Male
Rebecca: Supervior: Female

Total Supervior Female= ?????????
 
Back
Top