Hello, I'm trying to get better at using proper and succinct formulas.
Case in point, I have a formula that has multiple criteria from one column, using countifs. I'd like to simplify it with SUMPRODUCT but it's not working right.
Here's the formula I have (correctly returns 79)
=COUNTIFS(Table13[Action Overall Severity],"Orange",Table13[Current Action Status],"<>Cancelled",Table13[Current Action Status],"<>Complete",Table13[Current Action Status],"<>")
Here's the formula I'm trying (returns 837)
=SUMPRODUCT(COUNTIFS(Table13[Action Overall Severity],"Orange",Table13[Current Action Status],"<>"&{"Cancelled","Complete",""}))
Can somebody please help me straighten this out?
Bookmarks