myCompliments

Q: Find percentage of double false pairs within five two column sets

The situation is that I have four sets of two related columns, and those four sets are repeated over 17 sheets. They are all check boxes (basically and either or), and I've already got it set up to do quite a bit when one of the two is checked.

 

What I'm looking to figure out is whether it's possible to indicate the percentage of a two column pair both being false. I want to compare, over time (represented by all the sheets), how each column pair does.

 

Here's a screen shot. Currently, I'm manually marking the double false rows with red, but I'd like my 18th sheet, which collects information about the rest, to display quickly how well each of the column pairs is doing.

Screen Shot 2016-09-16 at 4.23.42 PM.png

iMac, OS X El Capitan (10.11.5)

Posted on Sep 16, 2016 1:30 PM

Close

Q: Find percentage of double false pairs within five two column sets

  • All replies
  • Helpful answers

  • by Wayne Contello,Solvedanswer

    Wayne Contello Wayne Contello Sep 17, 2016 6:09 AM in response to myCompliments
    Level 6 (19,282 points)
    iWork
    Sep 17, 2016 6:09 AM in response to myCompliments

    you can count double falses using the formula:

    =COUNTIFS(A, FALSE, B, FALSE)

    Screen Shot 2016-09-16 at 3.38.27 PM.png

     

    Perhaps showing some of you could show move of whats on a sheet, show the tables names, and what's on sheet 18.

     

    This will allow us to provide a solution specific to your situation

  • by Wayne Contello,Helpful

    Wayne Contello Wayne Contello Sep 17, 2016 6:09 AM in response to Wayne Contello
    Level 6 (19,282 points)
    iWork
    Sep 17, 2016 6:09 AM in response to Wayne Contello

    What I meant was....

     

    "Perhaps showing some of you could show move of whats on a sheet, show the tables names, and what's on sheet 18."

     

    should have read:

    Perhaps showing some of what you have done and more of whats on a sheet, show the tables names, and what's on sheet 18.

  • by myCompliments,

    myCompliments myCompliments Sep 17, 2016 6:08 AM in response to Wayne Contello
    Level 1 (4 points)
    iWork
    Sep 17, 2016 6:08 AM in response to Wayne Contello

    That's great, I missed that somehow. Thank you!

     

    I kept the other parts out for clarity, but this is exactly the solution I need. I can total double false column pairs and then pull each sheet's total into sheet 18.

     

    Here's a full shot of the double column setup. In this case, uncertainty counts against average. Sheet 18 doesn't have anything on it right now that has to do with this, but now that I know about COUNTIFS, it will. Or, maybe just a rolling average per sheet. Each sheet is going to get a quick assessment of uncertainty.

     

    Screen Shot 2016-09-17 at 9.02.20 AM.png

     

    "Result" is totaling against real world results, and feeding into different stats on sheet 18.