Hi,

I have an Array formula which is entered with CTRL + SHIFT + ENTER.

I'm wondering if I can achieve the same result with a Sumproduct formula or
something else.

The array Formula I have is as follows:

{=SUM(IF((July!$B$11:July!$B$2000)*(July!$F$11:Ju ly!$F$200=July!$BK$12)*(July!$K$11:July!$K$200=Jul y!AV11)*(July!$G$11:July!$G$200=0),July!$AK$11:Jul y!$AK$200))}