COUNTIFS with OR??

[will31]

Hi All,

I have some data which I have crafted simple COUNTIFS to count the number of time a department has a error comment. I would like to extend it so that the severity will count two different entries in the same formula rather than create two formula's (which is my bodge to get it to do what I want. Any ideas how to do this?

=COUNTIFS(Dept, $A3,Month,B$2,Severity,"Major")

 

[RoryA]

=SUM(COUNTIFS(Dept, $A3,Month,B$2,Severity,{"Major","Not so major"}))

 

[will31]

Works beautifuly. I tried an array without the SUM function and it didn't work.

Thanks Rory