How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Jess M. Your Own Question
Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 6964
Experience:  Computer Software Specialist for more than 10 years
Type Your Microsoft Office Question Here...
Jess M. is online now
A new question is answered every 9 seconds

HI I have a list of people in one column and their gender

Customer Question


I have a list of people in one column and their gender in another - in excel

i need to calculate at the bottom the total of M and the total of F
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  Jess M. replied 4 years ago.
Hi, welcome and thank you for your question. My name is Jess and I am glad to assist you today.

Since the list of people is in ONE column and so with their corresponding gender, you need to have a cell in the buttom that will add ALL of the M and all of the F. That is, there will be 2 rows like this:

Total Male: {formula}
Total Female: {formula}

Now, the formula to use is COUNTIF. It will count the cell that meets the criteria. If the column for your Gender is B, at the bottom you can have this formula:

Total Male: =COUNTIF(B1:B8,"M")

Here, B1:B8 is a sample range. You can make is B1:B1000 delending on your actual data.

For the Female, here is the formula:
Total Female =COUNTIF(B1:B8,"F")

Now, the formula means COUNT the cells in the range (B1:B8, or any range for that matter) if the content of the cell is F or M, depending on the gender contained in the cell.

Please download this sample Excel of mine showing the actual formula:

If you have trouble downloading my sample file, please let me know.

Here is my screen shot in case you are unable to download the file:

Please remember to rate my service once you have all the information you need. If you have any other questions, please ask me – I’ll be happy to respond. Thank you!

Best regards,