Results 1 to 9 of 9

Using a function to count the number of rows in which multiple values are true

Threaded View

  1. #1
    Registered User
    Join Date
    03-21-2013
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    7

    Using a function to count the number of rows in which multiple values are true

    Hello everyone...

    My first post here so please be gentle....

    I've read a few dozen threads and I've approached the vlookup, countif, if, sumproduct, and a handful of other strategies to no avail - I figure this is simple enough and I'm probably not doing it correctly but I'd love any help I can get. I've attached a file and I've detailed below what I'm trying to do....

    So I've got a rather small table of data that serves as a schedule for a soccer league. I'm hoping to create an automated standings page that pulls wins and losses from the table. Easy enough - but the kicker is that there are multiple divisions, and some of the divisions have identically named teams...for example, the tigers might be a team in the boys division as well as a team in the girls division, but those wins and losses must be counted separately.

    A simplified example of what I'd like to do is have a function that counts and displays the number of times that for every row where "girls" is in the division column AND "tigers" is in the winner column.

    I don't know if this is a good explanation but I'm here ready to try and rearticulate! Thanks for your time!
    Attached Files Attached Files
    Last edited by jimbowl; 04-17-2013 at 03:08 PM. Reason: Using a function to count the number of rows in which multiple values are true

Thread Information

Users Browsing this Thread

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

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