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: 6298
Experience:  Computer Software Specialist for more than 10 years
49766785
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

HI

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:
http://dl.dropbox.com/u/22865503/CountIF_sample.xlsx

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:

Attachments are only available to registered users.

Register Here

Attachments are only available to registered users.

Register Here

Attachments are only available to registered users.

Register Here
View Full Image

Attachments are only available to registered users.

Register Here


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

Related Microsoft Office Questions