I don't think OR and AND work well in array formulas. You could try:

=SUM(($B$3:$B$1000=M4)*($C$3:$C$1000=$AH$2)*((($F$ 3:$F$1000<0)+($J$3:$J$1000<0))0)*($H$3:$H$1000= 1))


"Rif" wrote:

They seemingly do not work as anticipated. I'm probably misinterpreting
something.

=SUM(($B$3:$B$1000=M4)*($C$3:$C$1000=$AH$2)*(OR($F $3:$F$1000<0,$J$3:$J$1000<0))*($H$3:$H$1000=1))

The OR section is what I am having trouble with. This formual returns
success when clearly this is not true. For example, in columns F and J, the
values are 0 but the above formula is counting them.

I do not want to use IFs. I can get it to work using IF. Still, I would
like to use ORs and ANDs. :)

To make it easier, strip out the