Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Trouble

  • 29-12-2011 5:15am
    #1
    subi
    Closed Accounts Posts: 2 ✭


    How do i compare 2 different values on an excel spreadsheet?? For example I have a column with the value male or female and then another column that says "likes icecream" with yes or no as the values. (there are several other likes in other columns too)

    I want to compare how many boys like icecream and how many girls like ice-cream but i don't know how!!

    Help would be much appreciated i am underpressure to have statistics ASAP

    thank you


Comments

  • #2
    sea_monkey
    Banned (with Prison Access) Posts: 755 ✭✭✭sea_monkey


    are you wanting to put them into a graph?


  • #3
    subi
    Closed Accounts Posts: 2 ✭subi


    No they are in a large graph already but i just want to crosstab those variables only and not the others also but i don't know how to do it !


  • #4
    bhickey
    Registered Users, Registered Users 2 Posts: 1,340 ✭✭✭bhickey


    Have a look at the COUNTIF function. So you'd count the instances of 'male' or 'female' in one column where the next colum contains 'likes icecream'.


  • #5
    Taltos
    Registered Users, Registered Users 2 Posts: 20,830 ✭✭✭✭Taltos


    bhickey wrote: »
    Have a look at the COUNTIF function. So you'd count the instances of 'male' or 'female' in one column where the next colum contains 'likes icecream'.

    You can also use pivots for this kind you thing - however from what you describe the solution above is alot more straightforward.


  • #6
    Mack_Attack
    Registered Users, Registered Users 2 Posts: 49 ✭Mack_Attack


    For performing a Count with multiple criteria I would use the following:

    =SUMPRODUCT(--(A1:A30="Male"),--(B1:B30="Yes"))

    Just change your ranges/criteria as appropriate


  • Advertisement
Advertisement