ImGoing2needaFormula
New Member
- Joined
- May 5, 2021
- Messages
- 1
- Office Version
- 365
- 2019
- Platform
- Windows
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.
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.