Results 1 to 6 of 6

counting text occurrance in multiple column

Threaded View

  1. #1
    Registered User
    Join Date
    02-09-2012
    Location
    florida
    MS-Off Ver
    Excel 2010
    Posts
    6

    Exclamation counting text occurrance in multiple column

    I'm using =COUNTIF(a1:a40,"word") to count the text occurance for a single column, but now I want to know what do i use to know the total number a word appeared that matches the other word from another column. I know it's confusing, i'm totally confuse now. I can't even explain it right.

    it's like this:
    Picture1.png


    i need to get the total of every white female and every white male.

    Thank you in advance!!
    Last edited by enialy; 02-20-2012 at 10:56 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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