Total of Females in a worksheet
 

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

Total of Females in a worksheet
 

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

Total of Females in a worksheet
 

On Feb 25, 10:07*am, "Ashish Mathur" wrote:
Hi,

You may use pivot tables.

--
Regards,

Ashish Mathur
Microsoft Excel MVPwww.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- Hide quoted text -

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

Total of Females in a worksheet
 

Hi,

Try this

=sumproduct((D10:D30="Supervisor")*(E10:E30="Femal e"))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Tia" wrote in message
...
On Feb 25, 10:07 am, "Ashish Mathur" wrote:
Hi,

You may use pivot tables.

--
Regards,

Ashish Mathur
Microsoft Excel MVPwww.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- Hide quoted text -

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