Excel.jpg

Hello,

Having problems with =MIN(IF formula as it appears to stop evaluating?

SUM Array works fine.

{=-SUM(IF((TB!$B$2:$B$50000={"0151-0000","0154-0000","0155-0000","0162-0000","0163-0000","0164-0000"})*(TB!$A$2:$A$50000<=$F$6)*(TB!$A$2:$A$50000>EOMONTH($F$6,-V$6)),TB!$H$2:$H$50000))}

The MIN Array below which is same Function Syntax as above only evaluates or considers "0151-0000" and ignores everything else. Hopefully I have provided sufficient details to help with this problem any help will be very much appreciated. Thanks!

{=-MIN(IF((TB!$B$2:$B$50000={"0151-0000","0154-0000","0155-0000","0162-0000","0163-0000","0164-0000"})*(TB!$A$2:$A$50000<=$F$6)*(TB!$A$2:$A$50000>EOMONTH($F$6,-V$6)),TB!$H$2:$H$50000))}