17 answers
If they both work broken out then they will also work together. You've got something going awry here, and you'll need to take a hard look at your data to see why. The formula is working as expected, so it must be the data that the formula is evaluating