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.
iMac, OS X El Capitan (10.11.5)
Posted on Sep 16, 2016 1:30 PM
you can count double falses using the formula:
=COUNTIFS(A, FALSE, B, FALSE)
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
Posted on Sep 17, 2016 6:09 AM


