Using Sumifs with an OR clause and cell Reference

[ImGoing2needaFormula]

Hey all, first time posting, though been lurking these boards for quite some time. I am in need of some assistance with a Sumifs/sumproduct that has an or statement with cell reference.
The formula which I know does not work is below.
=SUM(SUMIFS('Sheet2'!$J:$J,'Sheet2'!$F:$F,"LC",'Sheet2'!$C:$C,{A33,B33,C33}))
Column J on Sheet 1 has all the data I want sum'd (Dollars)
Column F I need to parse to make sure it meets the LC criteria (person)
And for the last criteria I need it to match one of the three critera (Type of product) Now these are going to change base upon the row
I had just been doing this formula =Sumifs(1)+Sumifs(2)+Sumifs(3) currently but was hoping I can cut the formula short and just have one formula.

 

[maabadi]

Welcome to MrExcel Message Board.
At this situation, you should use Cells Value Not Address, Then Change A33, B33 & C33 to their values at formula.

 

[maabadi]

Or Use Sumproduct if your range is not very big. I supposed your range is row 2:90 Then:

=SUMPRODUCT((Sheet2!$J$2:$J$90)*(Sheet2!$F$2:$F$90="LC")*((Sheet2!$C$2:$C$90=A33)+(Sheet2!$C$2:$C$90=B33)+(Sheet2!$C$2:$C$90=C33)))

But if your range is Long this formula take long time to respond:

=SUMPRODUCT((Sheet2!$J:$J)*(Sheet2!$F:$F="LC")*((Sheet2!$C:$C=A33)+(Sheet2!$C:$C=B33)+(Sheet2!$C:$C=C33)))

 

[Fluff]

Hi & welcome to MrExcel.
Another option

=SUM(SUMIFS('Sheet2'!$J:$J,'Sheet2'!$F:$F,"LC",'Sheet2'!$C:$C,A33:C33))

may need array entry in xl 2019