Total of Females in a worksheet

[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

 

[Ashish Mathur]

Hi,

You may use pivot tables.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Tia]

Hi,

You may use pivot tables.

--
Regards,

Ashish Mathur
Microsoft Excel MVPwww.ashishmathur.com








- Show quoted text -

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= ?????????

 

[Ashish Mathur]

Hi,

Try this

=sumproduct((D1030="Supervisor")*(E10:E30="Female"))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com