Results 1 to 12 of 12

counting numbers of two rows with two conditions

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2016
    Location
    Hamburg, Germany
    MS-Off Ver
    2007
    Posts
    11

    Post counting numbers of two rows with two conditions

    Dear smart people,

    I have a problem with Excel. I'm doing a bachelor thesis on Entrepreneurial Attitudes and handed out questionaires. I'm now trying to work with them and I am a bit stuck. Help is highly appreciated. My goal is to compare the answers of students from my home university with those of my abroad university. I have a row with the university (translated into number 1 or 2), and I have a row with the answers ranging form 1 to 7.


    Strongly disagree= 1
    Moderatly disagree= 2
    Slightly disagree = 3
    neither agree or disagree= 4
    Slightly agree= 5
    Moderatly agree= 6
    Strongly agree= 7

    I now want to count for each of the 7 answers, how many answered form my home university and how many answered from my abroad university.

    So if I want to do that for "Neither agree or disagree" for my home university I have two conditions: In the row of the "question" it needs to be a 4 and in the row of the "university" it needs to be a 1. And both need to be in the same column as well if I'm not mistaken.

    With Kind Regards,
    Why are you doing this to me Excel whyyyy?!
    Last edited by WhyExcelWhy?; 06-13-2016 at 03:01 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Need Help with Counting Function for multiple rows (with conditions)
    By CosmicChameleon in forum Excel General
    Replies: 4
    Last Post: 02-13-2015, 10:02 PM
  2. Counting of Rows in a Range with 2 conditions
    By gregorolaf in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2013, 06:43 PM
  3. [SOLVED] Counting all the past 15 rows of 22 numbers
    By khank in forum Excel General
    Replies: 4
    Last Post: 08-30-2012, 12:04 PM
  4. Counting rows satisfying two conditions
    By gozillasnack in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2007, 03:08 PM
  5. [SOLVED] Counting rows containing data (both numbers and text)
    By mconnolly in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  6. [SOLVED] Counting rows containing data (both numbers and text)
    By KL in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 06:05 AM
  7. [SOLVED] Counting rows containing data (both numbers and text)
    By mconnolly in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1