+ Reply to Thread
Results 1 to 2 of 2

Count number of times Multiple criteria is true

  1. #1
    Registered User
    Join Date
    02-19-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    11

    Count number of times Multiple criteria is true

    I am attempting to create an automated way to make a standings report based on a games project winner vs a games actual winner.

    On the attached sample sheet, I am wanting to count how many times U>V and AC>AD are true. If so then I would count that as a "Win" for the forecast, and count towards a culminative rollup in a separate column. However I do not want to count if there are no values in AC & AD (basically The game hasn't played yet).

    I really hope I explained this well enough. This is the building block to a larger project I am working with this data, but the cornerstone is gathering this data first.
    Attached Files Attached Files

  2. #2
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Count number of times Multiple criteria is true

    easiest way is to use a formula in lets say in cell AE2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    then drag formula down. 1 = it meets all your criteria. 0= it failed your criteria.
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 09-22-2021, 05:16 PM
  2. [SOLVED] Count the number of times a data appear based on multiple criteria between 2 dates
    By lati2008 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-22-2021, 03:53 PM
  3. Replies: 17
    Last Post: 08-12-2015, 04:35 AM
  4. Replies: 1
    Last Post: 02-21-2014, 09:09 PM
  5. Count number of times one value is higher than another IF criteria is true
    By LasseKaa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-17-2013, 11:28 AM
  6. How to count the number of times an expression is true
    By sherlock99 in forum Excel General
    Replies: 4
    Last Post: 06-22-2011, 06:46 AM
  7. Replies: 3
    Last Post: 02-03-2005, 06:06 AM

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