Is is possible to count    Max salary  of Male as well as    Max Salary of Female in an organization. For Exp -
Name Gender Salary
Rohan         M                   60000
Peeyush      M                  40000
Smita           F                   55000
Gauri           F                   35000
and so on. Using Function
manju shuklaAsked:
Who is Participating?
ProfessorJimJamConnect With a Mentor Commented:
For male =Max(if(B:B="M",C:C))
For female =Max(if(B:B="F",C:C))

Formula should be entered using control shift enter

Also the example is given that gender is in column B and salary is in column C

You can change those range to actual range in your workbook
JohnBusiness Consultant (Owner)Commented:
I use COUNTIF for this. Set M and F in a column and count the next column using the M/F column as the selector

JohnBusiness Consultant (Owner)Commented:
Ha!  Missed the MAX above - sorry
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Assuming E3=M and E4=F and data is in the range A2:C5 then try this....
In F3

Open in new window

and copy down. No need to use Ctrl+Shift+Enter, Enter alone is sufficient as this is a regular formula.

Also you may use the Pivot Table to get the desired output.

Please refer to the attached for details.
manju shuklaAuthor Commented:
Thanks, Thanks a lot. I have got my aswer.
manju shuklaAuthor Commented:
Grateful for help.
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Manju! Glad we could help.
you are welcome manju

closed as follows
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.