Results 1 to 9 of 9

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

Threaded View

jimbowl Using a function to count the... 04-17-2013, 11:36 AM
MarvinP Re: Not sure which function... 04-17-2013, 11:51 AM
jimbowl Re: Not sure which function... 04-17-2013, 12:21 PM
MarvinP Re: Not sure which function... 04-17-2013, 12:26 PM
jimbowl Re: Not sure which function... 04-17-2013, 12:47 PM
jimbowl Re: Not sure which function... 04-17-2013, 01:27 PM
jimbowl Re: Not sure which function... 04-17-2013, 01:36 PM
arlu1201 Re: Not sure which function... 04-17-2013, 02:32 PM
jimbowl Re: Using a function to count... 04-17-2013, 06:19 PM
  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