Countifs with or - but not as sumproduct

ID City State Client Subscriber
A NY NY Y Y

I want to `count IDs` that have `Client=Y and Subscriber=Y and (City=NY or State=NY)`.
Right now I am doing countifs(Client=Y and Subscriber=Y and City=NY and State=NY) + countifs(Client=Y and Subscriber=Y and City=NY and State<>NY) + countifs(Client=Y and Subscriber=Y and City<>NY and State=NY).

What would be the most straight forward way to use `countifs()`, given that `or()` can't be used?

Why would you have a problem using sumproduct?

You can shorten the formula using SUM and two arrays:

=SUM(COUNTIFS(A:A,"Y",B:B,"Y",C:C,{"NY","<>NY","NY"},D:D,{"<>NY","NY","NY"}))

which is the equivalent of adding the three counts you have now.