Does anyone know a more efficient way to write this? I seem to be having quite a bit of issues with excel giving me "not enough system resources" because I have about 30 slightly varied versions of this in my excel spread sheet.

```
=SUMPRODUCT((Data!B2:B1000="Human Resources")*(Data!E2:E1000<>"Resolved")*(Data!E2:E1000<>"Closed")*(Data!E2:E1000<>"Cancelled"))

```

I have looked into countifs but I can't seem to get that to work.