I have a list of 6 criteria but I want to add up 4 of them. When I try to use
< I get a result of 0.

This is the formula that isn't working.

=-(SUMPRODUCT('YTD ACTUALS Data'!$G$19:$G$5805,('YTD ACTUALS
Data'!$A$19:$A$5805=A26)*1,('YTD ACTUALS Data'!$D$19:$D$5805<"R
Returns")*1),('YTD ACTUALS Data'!$D$19:$D$5805<"C Create Returns Prov")*1)

Is there an efficient way of summing 4 of the 6 without adding the 4
individually?

Thanks
Rick