=SUMPRODUCT(--(OR(D1:D60=230,D17:D18=540)*(K1:K60=973)*(L1:L60=" 024")))
*B17:B18

use ctrl + shift + enter


On Nov 21, 3:14*pm, Jayen wrote:
My formula, which works fine, is
=SUMPRODUCT(--([file1]sheet1!$D$1:$D$60="230"),
--([file1]sheet1!$K$1:$K$60="973"), --([file1]sheet1!$L$1:$L$60="024"),
[file1]sheet1!$B$1:$B$60)

My problem is that for the first criteria, I want to check for either of two
values i.e. * (--([file1] sheet1!$D$1:$D$60="230" or “540”). *Can someone
please help with how to do this correctly? * I have tried using OR, * but
this does not work. *Is there any other function I could use if I cannot do
this with the SUMPRODUCT function?

--
Jayen