Forum Discussion
=COUNTIF with both AND and OR functions
How can I count multiple criteria from multiple columns but one of the columns can be any of several values? I'm trying to count the reason for Non-diagnostic specimens defined within a final di...
=SUM((D:D=A5)*(F:F=B1)*(ISNUMBER(SEARCH({"Hypocellular","acellular","insufficient"},K:K))))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.