Forum Discussion
Excel formula
I need to create a formula with nesting, I believe, to address if one OR the other is true. I tried IF/OR function as well as IF/AND. I keep getting error messages. HELP!
4 Replies
You can use the COUNTIFS function to count cells across multiple ranges based on one or several conditions.
The function is available in Excel 365, 2021, 2019, 2016, 2013, Excel 2010, and Excel 2007.
Here’s an example of how to use COUNTIFS with multiple criteria in the same column in Excel:
=IF(COUNTIFS(A1:A10,"Fail",A1:A10,"Pass")>0,"Fail","Pass")
This formula will return “Fail” if either of the criteria is met, and “Pass” if neither of the criteria is met.
I hope this helps!
Otherwise, I recommend you, as Mr.Hans Vogelaar
has already informed you, provide more detailed and specific information.
Please provide more detailed and specific information.
- Actually, I need to use COUNTIF x2 for the same range but different criteria. Only one of the criteria need met to render "Fail", "Pass"
If you would like help with this, please explain in detail what you want.
