I have this extemely large formula that is working fine, I want to define it
using the { } or funcunatily.

The current formula reads as:

=SUMPRODUCT(('Warehouse Management'!$F$15:$F$24="Apple")*('Warehouse
Management'!$D$15:$D$24<"FILL")*('Warehouse
Management'!$D$15:$D$24<"fill")*('Warehouse
Management'!$D$15:$D$24<"Fill")*('Warehouse
Management'!$D$15:$D$24<"")*('Warehouse Management'!$C$15:$C$24))

I tried but faild the following:

=SUMPRODUCT(('Warehouse Management'!$F$15:$F$24="Apple")*('Warehouse
Management'!$D$15:$D$24<{"FILL","fill","Fill",""} )*('Warehouse
Management'!$C$15:$C$24))

This doesnt seem to work, any ideas?

Thanks